Forum Discussion
Show active filters.
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.
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.
Thak you very much for sharing. It works perfect and I have to say: it is not that tedious and simply to achieve.
Two days ago a customer ask to have "Active filter" text solution and this solution fits perfectly. Thaks one more time.