Forum Discussion

yashgoyal's avatar
yashgoyal
New Member
4 years ago
Solved

Cluster Column Chart for column type data

Please help how to generate Cluster Column Chart for column type data on this type of data

GL DeptCurrent JANCurrent FebCurrent MarCurrent Apr
1529554444
15336557575757
1533650000
1535201111

 

 

Need Help
  • mahoneypat's avatar
    mahoneypat
    4 years ago

    You need to unpivot your data in the query editor. Select your GL Dept column, right click and choose "unpivot other columns". You will then have a three-column table including two new columns called attribute and value. You can rename those to month and whatever your values are, and then make your chart using the Month column as the legend.

     

    Pat

     

2 Replies

  • mahoneypat's avatar
    mahoneypat
    Microsoft Employee
    4 years ago

    You need to unpivot your data in the query editor. Select your GL Dept column, right click and choose "unpivot other columns". You will then have a three-column table including two new columns called attribute and value. You can rename those to month and whatever your values are, and then make your chart using the Month column as the legend.

     

    Pat