Compare data from one table by multiple slicers

[YouCanCallMeAl]

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:

• Slicer A -> (multi)select out of column "Variant"
• Slicer B -> independent (multi)select out of same column "Variant"

Compare the scenarios in a shared matrix visual:

Rows: 

Domain

 + Variant
   + ID
     + Tag

Values (in columns) based on Slicer A:

• Price-A
• Price-B

Values (in columns) based on Slicer B:

• Price-A
• Price-B

Delta Values (Delta between the 2 sliced Values)

• Price-A (Slicer A) minus Price A (Slicer B)
• Price-B (Slicer A) minus Price B (Slicer B)

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.

PBIX Download 

Would be glad if I can get some help.

[lbendlin]

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") ?

[YouCanCallMeAl]

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

• Price A (based on Slicer A) compared to Price A (based on Slicer B)
• Price B (based on Slicer A) compared to Price B (based on Slicer B)

[lbendlin]

Consider loading your table twice, and then use independent slicers.  Anything else will be hard to maintain.

[YouCanCallMeAl]

Not sure if this helps. I added the PBIX to my original post. 

Hope this helps.

[lbendlin]

you stored your pbix on enterprisedna and linked it here. Interesting approach, not sure if they will like that?