Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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!
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
User | Count |
---|---|
77 | |
74 | |
63 | |
61 | |
45 |
User | Count |
---|---|
108 | |
102 | |
93 | |
83 | |
64 |