November release of Power BI Desktop delivered a highly requested feature – ability to configure interaction between visual elements in a report. Here is a quick tutorial of the configuration options. I have a report with 4 visual elements, a card, a clustered column chart, a bar chart and a donut chart. By default, when … Continue reading Power BI Desktop: Interaction between Visuals
Earlier this year, new version of DAX was released. One of the key features with this release is the support for variables. Variables makes writing DAX code easier. Variables also make code easier to read and understand. Download sample data here. Data represents sales for a particular store. Products are categorized by seasonality and color. … Continue reading POWER BI TUTORIAL : Using Variables in DAX
In Power BI Desktop, there are multiple options available when using Merge Query feature. This tutorial reviews each of the options. Data for the tutorial can be obtained by downloading Excel file from here . The file has Product sheet which has details of all the products my company sells The file also has a … Continue reading Power BI Desktop : Merge Query Options
Refresh has been a bit of an issue with Power BI. The "old" version of Power BI bundled with Office 365 supports refreshing Power Pivot models against a lot of different data source types using the Power BI Gateway. The "new" version at PowerBI.com until recently only supported refresh of Power Pivot models and only … Continue reading Power BI Now Supports Refresh for Designer-built Datasets
This is a huge win for those of us who try to use Power BI for market basket analysis. Here is a the link to documentation https://support.office.com/en-us/article/CONCATENATEX-Function-DAX-ae3ba882-c260-4a56-82d1-70ee66451b39 The tutorial on how to use this function for market basket analysis will be available shortly.
I am sure it is only a matter of days (hours ?) before Power Query is updated with the Google Analytics connector as well, but I find it very interesting that new Power Query features are now first released in Power BI Designer. I had speculated earlier that Microsoft would/should focus on Designer as the … Continue reading Power BI Designer Now Connects to Google Analytics… Power Query Doesn’t
Quick disclaimer, the Power BI Designer is in preview right now and as such it is lacking a number of very important features that some consider minimally necessary for the product to be usable (a few thoughts on where the product is in its current state from my perspective could be found here). At the … Continue reading Power BI Tutorial: Many to Many Relationship using Power BI Designer
Although Microsoft has not yet given us an official roadmap for its Power BI offering, I believe it is not beyond the realm of reason to share some educated and uneducated guesses about where the Power BI Designer might fit in. Philosophically speaking, I have heard two opinions about Microsoft creating a standalone tool that … Continue reading What Is Power BI Designer And Why You Should Start Playing With It Right Now