Adding average on visual

[abukapsoun]

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

[Anonymous · Accepted solution]

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

[amitchandak]

@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

[abukapsoun]

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