Forum Discussion
Exclude Slicer Selection
| SUBCATEGORY | Bill Date | Item Name | Profit Margin Amount | Profit Margin Percentage Over Total | Rank |
| LIQUOR | Wednesday,March 1,2023 | JINRO SOJU 360ML GREEN GRAPE | 15.048 | 0.104135431 | 80.04 |
| BEERS | Friday,July 28,2023 | TIGER BEER BOTTLE 660ML | 15.048 | 0.104135431 | 80.04 |
| BEERS | Sunday,June 25,2023 | HEINEKEN BEER CAN 320ML | 13.08 | 0.090516443 | 80.04 |
| BEERS | Monday,June 19,2023 | TIGER BEER BOTTLE 660ML | 12.54 | 0.086779525 | 80.04 |
| BEERS | Monday,January 2,2023 | TIGER BEER BOTTLE 660ML | 11.94 | 0.082627395 | 80.04 |
| BEERS LONG CAN | Monday,June 19,2023 | CONNOR`S 500ML | 10.74 | 0.074323134 | 80.04 |
Above is my sample data.
Hi @PaulDBrown, and anyone who can help, I'm trying to dynamically visualize a list of Subcategory that is excluded when I apply any of the 3 slicers. All my visuals and slicers are based on one table.
Your help would mean alot:)
Below is what I expect to show based on the sample data. I'm trying to visualize two group of products which is the top 80% and bottom 20% profit contributor. At the moment, I've all the visuals works and the 3 slicers work dynamically for e.g if choose 80.04 group, the subcategory slicer will only show the involved 33 subcategory out of total 51 subcategory, I'm trying to list the balance left out subcategory which is 18 and their items dynamically when any of these 3 slicers are applied.
2 Replies
- Ritaf1983Super User
Hi diana_989
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523- diana_989New Member
Hi @Ritaf1983, I've added the sample data and the expected outcome as you suggested.
Thank you for the suggestion. Please let me know if you need more clarification.