Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Show active filters.

Hello.   I have a very extensive report with a lot of slicers.   What I need is something that shows me the filters applied (or slicers) at the moment. It dynamically should change when a slicer ...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    Ok... I achieved a solution... it is not very orthodox but it works fine... Very tedious to write...

     

    It consists in a Measure of more than 120 lines (because the big number of columns and tables) with a text result that I can insert into a Card visualization or a table for better viewing.

     

    The approximate formula syntax of the measure is like this:

     

    _Active filters_ = 
"FilterSubsection:"
&IF(ISFILTERED(Table1[Column1]);
    UNICHAR(10)&"- StringColumnName: "& CONCATENATEX(VALUES(Table1[Column1]);Table1[Column1];", "))
&IF(ISFILTERED(Table1[Column2])
... (etc)

    Where u see Table1 you can refer to Table2, Table3 an so on.

    UNICHAR(10) is a newline character and & simbol is to concatenate strings.

     

    Hope this serves to someone in the future and really hope that the PBI team include a feature to achieve this easier.

     

    Thanks.

KostaMadorsky's avatar
KostaMadorsky
Regular Visitor
4 years ago

I know it's an old topic, but just wanted to share an awesome video that shown how you can generate the filtersContext measure just in 2 clicks in DAX Studio:

https://www.youtube.com/watch?v=kccmckYOmbw&ab_channel=SQLBI

 

In my case, it generated a 1600 line measure 🙂

 

Then just drop it onto a Table visual and you will see a list of applied filters on specific table or even all of the tables.

 

Super helpful when you are trying to debug some DAX measure or if you just want to show to end user all the filters applied in a tooltip.

kazet_vo's avatar
kazet_vo
Regular Visitor
4 years ago

This is really a great hint! Thank you!