Exclude value via a slicer

[Anonymous]

Hi,

I'm making a sales report and I want to exclude sales orders based on a characteristic.

Let say that every order can be categorized as A, B or C.

Example:

Sales order 1 | A

Sales order 2 | B

Sales order 3 | C

Sales order 4 | A.

Now I want to make a filter with two options, either 'showing all orders'  (in this example 4) or 'showing all orders except A' (in this example 2).

Can you help we with this?

Thx!

[Anonymous · Accepted solution]

Hi,

I'm just giving a try.

Download the Solution File

Please check the solution and let me know if it helps you.

Regards,

Pavan.

[Greg_Deckler]

Typically you would use a slicer such that you would select everything and then unselect the items that you want to exclude. That being said, I have done some things with switching up the behavior of slicers like in this Inverse Aggregator here:

https://community.powerbi.com/t5/Quick-Measures-Gallery/Inverse-Aggregator/m-p/342266