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.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Anonymous Thanks a lot for the fast response and sorry for the dealy but i was out of office.

 

I did tried hundreds of changes before i post this, your sentence "should" do exactly what i am looking for but it does not work, it seems to appears and error with & I have tried, just with MIN, or with MAX, with less text, with more parenthesis and hundreds of combinations, but it does not work, i am out of ideas. If you have any i would love to hear them.

 

Thanks in advance,

Angel

Anonymous's avatar
Anonymous
Not applicable
7 years ago

I don't know... you said about syntax error with &...    if there is nothing before the formula above posted, then remove the first & in "

&IF(ISFILTERED [...]

", & it's used to concatenate text

 

Could you post the error you are getting?

 

 

  • Shaina12's avatar
    Shaina12
    New Member
    7 years ago

    Hi Everyone,

     

    I tried using the method to show filters, it works fine but I am unable to display filters in different lines (Line break) when I am viewing the measure in a card.

    I am not creating measure in Query Editor but on report view itself. Please let me know hoe we can insert line breaks between the filters

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      string = "a" & UNICHAR(10) & "a"

       

      UNICHAR(10) is the line break char

       

      Regards