Separate business names from technical names using SSAS and Power BI
I have heard this question come up now and then where someone wants to separate the names and columns seen by users from the names... Read more
Category: Power BI
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
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