Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Solved! Go to Solution.
Hi,
I'm just giving a try.
Please check the solution and let me know if it helps you.
Regards,
Pavan.
Hi,
I'm just giving a try.
Please check the solution and let me know if it helps you.
Regards,
Pavan.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |