Forum Discussion

markmess77's avatar
markmess77
Resolver I
6 years ago
Solved

How to display filtered values?

I have several filters in my report. When filtering through each, it can be easy to forget exactly which filters have been selected. I have attempted to resolve this issue by using conditional format...
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    6 years ago

    You can use the following measure:

    Measure = IF(ISFILTERED('Table'[Item 2 Progress]);IF(COUNTROWS(VALUES('Table'[Item 2 Progress])) >=5;"Multiple";"| Progress -" & CONCATENATEX(VALUES('Table'[Item 2 Progress]);'Table'[Item 2 Progress];", "));"")

    Where 
    Table Item 2 Progress = your field you filter on.
    >=5 if there are 5 or more filters it will show "Multiple" you can change this to whatever you want.
    If there is no filter it will show nothing. And if there is a filter it will look like this: (ofcourse you can change this too)

     
    Note: It looks like -10 but that because there is a - in the measure i used. 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

You can use the following measure:

Measure = IF(ISFILTERED('Table'[Item 2 Progress]);IF(COUNTROWS(VALUES('Table'[Item 2 Progress])) >=5;"Multiple";"| Progress -" & CONCATENATEX(VALUES('Table'[Item 2 Progress]);'Table'[Item 2 Progress];", "));"")

Where 
Table Item 2 Progress = your field you filter on.
>=5 if there are 5 or more filters it will show "Multiple" you can change this to whatever you want.
If there is no filter it will show nothing. And if there is a filter it will look like this: (ofcourse you can change this too)

 
Note: It looks like -10 but that because there is a - in the measure i used. 

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Eric,

Greeting of the Day!

I have tried with above measure. It really helpfull for me.

But, When there is no filter applied to any of the slicer it showing as "(Blank)". Refer snip for more information.

Is there any possiblite to make No Filters applied note instead of Blank.