• Antriksh Sharma

Power BI: Visualizing Filter context

Updated: Apr 8

If there is one thing every DAX developer has ever dreamt about is to be able to view the filter context inside Power BI to debug DAX code and understand all the filters that are currently active outside of the measure being evaluated

As of now there is no tool to do that but luckily there is a small hack that you can use to get info about all of the filters in one single place.

To begin you first need to:

Connect to DAX Studio right click on any table in metadata pane and Select Define Filter Dump Measure (All Table):

Copy the code generated by DAX Studio and return to Power BI

Create a measure and paste the code removing the DEFINE and MEASURE statement

Create a blank page in Power BI and change the Page Information Name and Page Size Type to Tooltip and add a card visual and insert your measure in the card visual.

Go to your report and select the visual on which you want to see the filter context, and enable tooltip

Only thing left now is to hover over the report and experience the magic 🙂

19 views0 comments

Recent Posts

See All

Tabular Editor 3 Course

TE3 is the ultimate development tool for creating Tabular Model and recently I got an opportunity to make a full fledged course on it for Enterprise DNA. Here is a post about that and how you can secu