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.

v-angzheng-msft's avatar
v-angzheng-msft
Icon for Community Support rankCommunity Support
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

    This is very helpful, thank you!