cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
powerbinoobster
Frequent Visitor

Create a month to month chart of month averages

I want to create a graph like this:

Screenshot 2022-09-20 125532.png

I have a table of data for each month where I can calculate the average and create visuals with it, but how would I get access to that averages to create a chart like this with the average of each department for each month.

1 ACCEPTED SOLUTION
HoangHugo
Solution Specialist
Solution Specialist

Hi

If your data table have one Dapartment column, one Value column to calculate average, one  Month column. It is possible.

First, creat a Measure = AVERAGE(Value column)

 

Use Cluster Column Chart to show like your expected visual

You add Department column to "Axis", Measure average to "Value", and Month Column to  "Legend"

View solution in original post

1 REPLY 1
HoangHugo
Solution Specialist
Solution Specialist

Hi

If your data table have one Dapartment column, one Value column to calculate average, one  Month column. It is possible.

First, creat a Measure = AVERAGE(Value column)

 

Use Cluster Column Chart to show like your expected visual

You add Department column to "Axis", Measure average to "Value", and Month Column to  "Legend"

Helpful resources

Announcements
November 2022 Update

Check it Out!

Click here to read more about the November 2022 updates!

Microsoft 365 Conference â__ December 6-8, 2022

Microsoft 365 Conference - 06-08 December

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.