Forum Discussion

Jakub_Poweska11's avatar
1 year ago
Solved

How to create comparison dashboards between two categories?

Hello All, Im looking for inspiration how to create a good comparison dashboard between two categories inside different dimensions? Basically idea: - On the top i want to have field parameter, whe...
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi Jakub_Poweska11 

     

    Please refer to this:
    Here's a sample:

    In the power query, Duplicate the Table then select the Platform and Group columns and click unpivot the columns:

     

    The result:

     

    Duplicate the table(2):

    Apply and Close.

    Create 2 Slicers with the Table(2)[Attribute] and Table(2)[Attribute]:

     

    Then give them the same name to create Sync slicer on one page:

    Hide one of them:

    Create 2 Slicers with Table(2)[Value] and Table(3)[Value]:

    Finally create a clustered column chart, the result is as follow:

     

     

    Best Regards

    Zhengdong Xu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.