Use IsInScope to get the right hierarchy level in DAX
In the November release of Power BI desktop we introduced a new DAX expression that is really great. Working with hierarchies in DAX have always... Read more
Category: Power BI
Embed Power BI reports in SharePoint online using Apps
Last week I was trying to embed a Power BI report into a SharePoint online page. I wanted users in my organization with a free... Read more
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
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