Power BI Desktop: Interaction between Visuals

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

POWER BI TUTORIAL : Using Variables in DAX

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

Power BI Now Supports Refresh for Designer-built Datasets

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

Power BI Designer Now Connects to Google Analytics… Power Query Doesn’t

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

Power BI Tutorial: Many to Many Relationship using Power BI Designer

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