Forum Discussion

YouCanCallMeAl's avatar
YouCanCallMeAl
Frequent Visitor
2 years ago

Compare data from one table by multiple slicers

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 P...
Need Help
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

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's avatar
YouCanCallMeAl
Frequent Visitor
2 years ago

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's avatar
    lbendlin
    Icon for Super User rankSuper User
    2 years ago

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

    • YouCanCallMeAl's avatar
      YouCanCallMeAl
      Frequent Visitor
      2 years ago

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

      Hope this helps.

      • lbendlin's avatar
        lbendlin
        Icon for Super User rankSuper User
        2 years ago

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