Creating a Hyperlink with filters through DAX
Thanks to two recent Power BI features it now possible to generate a link on the fly using DAX to go to a new report... Read more
Category: Power BI
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
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