Forum Discussion

newbie_sam's avatar
newbie_sam
Frequent Visitor
9 years ago
Solved

Displaying Average value by category in bar chart

Hi,   I have a columns of data that looks like this:   In my bar chart I want it to show the averages by these categories by Year, but the bar chart doesn't seem to be able to switch on row...
Need Help
  • v-chuncz-msft's avatar
    v-chuncz-msft
    9 years ago

    newbie_sam,

     

    You need to select Unpivot Columns in Query Editor first, then drag Attribute to Axis.

v-chuncz-msft's avatar
v-chuncz-msft
Icon for Community Support rankCommunity Support
9 years ago

newbie_sam,

 

You need to select Unpivot Columns in Query Editor first, then drag Attribute to Axis.

newbie_sam's avatar
newbie_sam
Frequent Visitor
9 years ago

Thanks I figure that out eventually! :)