Showing KPI’s in a table or Matrix with Power BI
Got a question today on how we can do KPI’s in the matrix or table with Power BI, just like we can with PowerPivot through... Read more
Category: Power BI
Sorting by a measure not part of the visual in Power BI
Every now and then this request comes up, I want to sort by a measure that is not part of the visual. Even though it... Read more
Dynamic relationships based on the selection
Got an interesting question recently where someone wanted to be able to switch the relationships automatically based on which slicer was selected. Take the following... Read more
To DirectQuery or Not to DirectQuery, that is the question..
Usually I start my blog posts with an interesting question I got, this time we will do the reverse. I want to talk about a... Read more
How to turn on SSAS profiler traces in Power BI desktop
Just a quick post today. Power BI desktop has a feature to turn on the SSAS profile traces that allows you to see all the... Read more
Change your Power BI report to point to an external SSAS model
A common questions I get is to change the connection string to from my report to SSAS after I move my Power BI desktop file... Read more
Currency conversion in DAX for Power BI and SSAS
Another interesting question that came up recently is how to do currency conversion in Power BI. My colleague Jeffrey Wang had a very neat solution... Read more
Using CUSTOMDATA and On-Premises SSAS with Power BI Embedded
Another Power BI embedded blog post while I have a playground up and running. Often when you want to use SSAS with Power BI embedded... Read more