How to display what filter values are applied to data

[szub]

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!

[v-luwang-msft]

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

[Pragati11 · Accepted 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:

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