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.
Dear Community,
I would like to compare data in a matrix visual that is present in one table by the use of multiple slicers.
The table is structured like
Domain | Variant | ID | Tag | Price-A | Price-B |
D2 | V2 | ID1 | T2 | 123,34 | 32423,1 |
D1 | V2 | ID4 | T1 | 232,23 | 4324,33 |
D5 | V4 | ID4 | T2 | 23324,1 | 324 |
D4 | V3 | ID5 | T1 | 2344 | 553,9 |
D2 | V1 | ID2 | T3 | 45645,2 | 3345,55 |
... |
I would like to compare variants by slicers:
Compare the scenarios in a shared matrix visual:
Rows:
Domain
+ Variant
+ ID
+ Tag
Values (in columns) based on Slicer A:
Values (in columns) based on Slicer B:
Delta Values (Delta between the 2 sliced Values)
Goal is to filter the Variant based on the 2 slicers and to compare them.
Attached is the pbix example where I started to work with. The red x mark the visuals that do not work yet.
Would be glad if I can get some help.
What exactly are you trying to compare? Is that something your users can do by themselves when you give them the power to use custom filters (and "personalize visuals") ?
Thanks for your feedback @lbendlin
I just revised my post and added a sketch.
Yes, the user shall be able to set the slicers and the result is shown in one matrix visual. So that we are able to compare within the same structure.
The Prices shall be comparable wihin their category, so
Consider loading your table twice, and then use independent slicers. Anything else will be hard to maintain.
Not sure if this helps. I added the PBIX to my original post.
Hope this helps.
you stored your pbix on enterprisedna and linked it here. Interesting approach, not sure if they will like that?
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
88 | |
82 | |
65 | |
64 | |
58 |
User | Count |
---|---|
171 | |
115 | |
109 | |
74 | |
69 |