Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello,
I have a report that has many filter options (15+) and multiple values could be chosen in one filter. Because many of the filters have more options than can be displayed without scrolling, my users would like to be able to know what filter values are applied to the tables/visuals they are viewing. When I searched for solutions, what I find seems to apply if only one selection is chosen in a single filter, not multiple.
I am hoping there is a way to display all selected values for all filters.
Any guidance is appreciated!
Solved! Go to Solution.
Hi @szub ,
First thing really curious to know that is the requirement really to have like 15+ slicers/filters on a single report page?
If it is true, seems a weird requirement to me. 🙂
Won't ask further questions and will suggest 2 approaches that I can think of right now.
Consider the following scenario where I have got the following:
Now whenever, you make a selection in your slicer, the multi-row card visual will display values based on your selection in the slicer on this report page. See below:
So, this is one way you can use to display multiple selections from a slicer on your report page.
Similarly you can create this for multiple slicers on your page.
But, this approach may end being cumbersome when you have like 15+ slicers on your report page.
Another way could be to move all your slicers to Filter Pane in Power BI Desktop.
So, whenever you select something in your filters, the selected values are highlighted as shown:
Thanks,
Pragati
Hi @szub ,
Try like below :
Filters Selected (All Except version) =
IF (
ISFILTERED ( MyTable[MyColumn] ),
VAR ExcludedValues =
EXCEPT ( ALL ( MyTable[Column] ), FILTERS ( MyTable[MyColumn] ) )
RETURN
"All Except " & CONCATENATEX ( ExcludedValues, MyTable[MyColumn], ", " ),
"ALL"
)
refer :https://community.powerbi.com/t5/Desktop/Text-field-to-show-the-selected-filter/m-p/276520
Wish it is helpful for you!
Best Regards
Lucien
Hi @szub ,
First thing really curious to know that is the requirement really to have like 15+ slicers/filters on a single report page?
If it is true, seems a weird requirement to me. 🙂
Won't ask further questions and will suggest 2 approaches that I can think of right now.
Consider the following scenario where I have got the following:
Now whenever, you make a selection in your slicer, the multi-row card visual will display values based on your selection in the slicer on this report page. See below:
So, this is one way you can use to display multiple selections from a slicer on your report page.
Similarly you can create this for multiple slicers on your page.
But, this approach may end being cumbersome when you have like 15+ slicers on your report page.
Another way could be to move all your slicers to Filter Pane in Power BI Desktop.
So, whenever you select something in your filters, the selected values are highlighted as shown:
Thanks,
Pragati
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
84 | |
83 | |
64 | |
60 | |
55 |
User | Count |
---|---|
179 | |
108 | |
105 | |
71 | |
70 |