Using slicer to filter with Select All too

[Anonymous]

Hi,

I have a table with 50 different teams.

I am using a slicer to show data for each of those teams when they are selected in the slicer. (i.e all visuals change when different teams are selected)

Now, only 40 of the teams are relevant in my scenario (so I do not want the data to show for the other 10 teams).

Selecting individual teams and even multiple teams (via CTRL) shows the correct data.

However, I have also added the 'Select All' option.

Problem: When I press the select all checkbox - it removes the filter and thus data for all 50 teams show and skews my result. I want the 'select all' to only show the 40 teams that are listed in the slicer....

Any thoughts?

[amitchandak · Accepted solution]

@Anonymous , have a report(All page) or page level filter and remove those 10 teams.

https://docs.microsoft.com/en-us/power-bi/create-reports/power-bi-report-add-filter

[Anonymous]

Good trick - thanks and so obvious when you think about it....clearly I didnt think enough!