Exclude Slicer Selection

[diana_989]

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.

[Ritaf1983]

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_989]

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.