Create a month to month chart of month averages

[powerbinoobster]

I want to create a graph like this:

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.

[HoangHugo · Accepted solution]

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"