Time intelligence solved with modelling and crossfilter instead of DAX measures
A while ago I came across this interesting time intelligence solution that doesn’t use DAX measures to do time intelligence but rather solves it through... Read more
Category: DAX
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
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
Using variables to split up your calculations
Got a DAX question recently that I solved using variables. When I walked them through the solution someone exclaimed “I didn’t know you can do... 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
Dynamically switching axis on visuals with Power BI
An interesting visualization pattern I have seen is that some customers want to be able to switch the axis on the chart dynamically using 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