Slicer: Exclude all instead of Select All

[abalgir]

Hello,

I am looking to exclude a set of IDs from all reports.

I use the slicer visual to get the data I am looking for, and I want to exclude them all from the report (I cannot select one by one since I might have 100th). Is there a way to do it?

Thank you

[v-xicai · Accepted solution]

Hi @abalgir ,

You can create a Flag table which has only one column containing two values "Need" and "NonNeed", for more details: https://community.powerbi.com/t5/Desktop/Exclude-vs-All-Slicer/td-p/404405.

Best Regards,

Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.