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 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
string = "a" & UNICHAR(10) & "a"
UNICHAR(10) is the line break char
Regards