Forum Discussion
Exclude value via a slicer
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!
- Anonymous8 years ago
Hi,
I'm just giving a try.
Please check the solution and let me know if it helps you.
Regards,
Pavan.
2 Replies
- AnonymousNot applicable
Hi,
I'm just giving a try.
Please check the solution and let me know if it helps you.
Regards,
Pavan.
- Greg_Deckler
Community Champion
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