Forum Discussion

szub's avatar
szub
Icon for Helper III rankHelper III
5 years ago
Solved

How to display what filter values are applied to data

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!

Need Help
  • Pragati11's avatar
    Pragati11
    5 years ago

    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:

    1. Visual to display details
    2. Slicer
    3. Multi-row card visual to display selected values in the slicer

    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

2 Replies

  • Pragati11's avatar
    Pragati11
    Icon for Super User rankSuper User
    5 years ago

    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:

    1. Visual to display details
    2. Slicer
    3. Multi-row card visual to display selected values in the slicer

    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