Forum Discussion

diana_989's avatar
diana_989
New Member
3 years ago

Exclude Slicer Selection

SUBCATEGORYBill DateItem NameProfit Margin AmountProfit Margin Percentage Over TotalRank
LIQUORWednesday,March 1,2023JINRO SOJU 360ML GREEN GRAPE15.0480.10413543180.04
BEERSFriday,July 28,2023TIGER BEER BOTTLE 660ML15.0480.10413543180.04
BEERSSunday,June 25,2023HEINEKEN BEER CAN 320ML13.080.09051644380.04
BEERSMonday,June 19,2023TIGER BEER BOTTLE 660ML12.540.08677952580.04
BEERSMonday,January 2,2023TIGER BEER BOTTLE 660ML11.940.08262739580.04
BEERS LONG CANMonday,June 19,2023CONNOR`S 500ML10.740.07432313480.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