Forum Discussion

samdep's avatar
samdep
Icon for Advocate II rankAdvocate II
4 years ago
Solved

X-Axis Bar Chart Groupings

Hi Community!   I have a table of data similar to the below:   Name                  Speed    Agility     Purpose John                    4            3             2 John's Manager   3        ...
Need Help
  • v-angzheng-msft's avatar
    v-angzheng-msft
    4 years ago

    Hi, samdep 

    Yes, you need to unpivot the columns. But for what you mentioned above, I would recommend to unpivot all three fields( Speed,Agility,Purpose), and then filter the fields you want to compare.

     

    Result:

     

     

    Best Regards,
    Community Support Team _ Zeon Zheng


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

samdep's avatar
samdep
Icon for Advocate II rankAdvocate II
4 years ago

Figured it out. If anyone stumbles on this and is looking for an answer, I unpivoted my data in PQ and the field (Agility, Speed) became rows and from there, I was able to group by row and compare the same data point for two users side-by-side.