Invert Selection

[Anonymous]

Hello,

I have a table like this:

Country          Product

US                     AA

UK                     BB

Australia            AB

NZ                     AA

Cannada            BB

If I I use a Slicer and select ''Product as AA"  -> I will get the list of Countries that uses product AA (US and NZ).

But, is there a way to display the Countries that doesn't use AA product i.e., If I select AA in Slicer, it should display UK, Australia and Cannada.

Any sort of help is much appreciated.

Thanks

[v-chuncz-msft · Accepted solution]

@Anonymous ,

You may refer to the following post.

https://community.powerbi.com/t5/Desktop/Tricky-Slicer-Options/m-p/573381#M270846