Forum Discussion
Adding average on visual
Hi,
I have the below visual, where the x axis is the date & Time. How can I add another line on the grapth showing the average per day for each slot?
thank you
Hi abukapsoun ,
I created some data:
Here are the steps you can follow：
1. Create measure.
Avg = AVERAGEX(FILTER(ALL('Table'),'Table'[Date]=MAX('Table'[Date])),[Amount])2. Place it in Tooltips.
3. Result.
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
3 Replies
abukapsoun , Check Y-Axis and X-Axis constant line under Analytics pane. You can use measure there
https://docs.microsoft.com/en-us/power-bi/desktop-analytics-pane
Thank you amitchandak But that average line is giving the average of all the series, and not average per day. I want to have a point showing the average per day for each day
Hi abukapsoun ,
I created some data:
Here are the steps you can follow：
1. Create measure.
Avg = AVERAGEX(FILTER(ALL('Table'),'Table'[Date]=MAX('Table'[Date])),[Amount])2. Place it in Tooltips.
3. Result.
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
