Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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
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
@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
User | Count |
---|---|
93 | |
83 | |
77 | |
73 | |
66 |
User | Count |
---|---|
115 | |
104 | |
93 | |
64 | |
61 |