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: DAX
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
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
Filter data based on a comma separated list using CALCULATE and PATHCONTAINS, even with external models!
Another interesting question I got this week kind of extends on the previous blog posts where I used disconnected slicers to filter data but this... Read more