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.
Hi guys,
Got a (i hope) simple question.
I cannot figure it out. I need the red line to be the average over the entire table. Right now it shows the average per month, but it needs to calculate all the dark columns and show the average in a straight line like the black line below:
So it should count up all the dark values, and divide it by the number of selected months/days
Anyone got a trick for this?
Solved! Go to Solution.
If you select your visual, then the analytics icon (magnifying glass) over in the visualisations pane you should then have a number of options including "Average Line" you can then add one or more lines and dictate which measure these are applied to. Hope this helps.
If you select your visual, then the analytics icon (magnifying glass) over in the visualisations pane you should then have a number of options including "Average Line" you can then add one or more lines and dictate which measure these are applied to. Hope this helps.
Edit
That worked, thanks!
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 |
---|---|
107 | |
94 | |
77 | |
63 | |
50 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |