Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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"
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"
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
80 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |