Forum Discussion

LouisB's avatar
LouisB
Frequent Visitor
8 years ago
Solved

Creating a Graph of Columns Average

Hello everyone,

 

I am a new user and I am stuck after few hours... And impossible to find a solution on the forum!

 

I have a table with different Columns: January, February, March etc..

and then each rows correspond to an user. I have the monthly electricity consumption of every user.

 

I want to display on a graph the average of each column by the month to compare the average of users consumption per month.

 

I have created first a graph with only the average of each columns on the Y-Axis, but It does'nt look good (photo)...

How can I do to have the months on my X-Axis ?

Thank you for your help !

Need Help
  • v-piga-msft's avatar
    v-piga-msft
    8 years ago

    Hi LouisB,

     

    Thanks for your deatils data sample, but is only the month columns useful?

     

    After unpivot your data model, you will get the Month column and another Value column.

     

    Is that the value column the electricity consumption per month?

     

    If you want to calculate the average, you could use calculate(average([value])).

     

    If you still need help, could you share your desired average value so that I can know what value you want to get?

     

    Best Regards,

    Cherry

6 Replies