Matrix slicer

[MS2121]

Hi

I have a matrix with customer names (rows), product categories (columns) and sales numbers (value).

I would like to add a slicer for the categories. When I select product category A, I want to see all the customers with sales numbers greater than 0 in category A

AND

their sales numbers in the other categories.

With the standard slicer I can only see the customers with sales numbers greater than 0. The other categories disappear.

Is there a way to prevent that the other columns disappear when I use the slicer?

Thank you very much in advance!

[Anonymous]

Hi@MS2121，

I'm not quite sure I clearly understand your needs. Share your sample data and expected result to me if you don't have any confidential Information.

Best Regards,

Caitlyn Yan