Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 formatting in a text box. The SELECTEDVALUE function works great, except when more than one option in the filter is selected. In this case, the alternate result is selected rather than the 2+ filtered values. I have been trying to use other function such as ALLSELECTED, IF, and VALUES but have not yet been able to make something that works.
Is there a way that SELECTEDVALUE can return more than one value?
Please let me know if you require any more information, I'd be more than happy to do so.
Solved! Go to Solution.
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.
Quality over Quantity
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.
Quality over Quantity
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.
I did not get completely. But concatenatex, can help you show value at one place
https://docs.microsoft.com/en-us/dax/concatenatex-function-dax
concatenatex(allselected(table]),table[column])
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |