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.

newbie_sam's avatar
newbie_sam
Frequent Visitor
9 years ago

How do I do that? 

 

I cant place more than 1 data field in the legend, so which data field should i pull to the legend? i'm puzzled, would be great if you can guide me through.

@smoupre wrote:

Switch your Axis with your Legend.

 

newbie_sam's avatar
newbie_sam
Frequent Visitor
9 years ago

Hi, when i pulled the "Year" to the legend, I can only add only 1 datafield into the bar chart..why?:womansad:

  • 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! :)