Forum Discussion
Show active filters.
- Anonymous8 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.
Hi Anonymous,
After test, the measure and column are not supported in text box, you can create a card visual to display the measure. You can review the following feature request and vote it, you also create an idea here.
Description to the Calculated Columns & Measures
Best Regards,
Angelia