Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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 |
---|---|
85 | |
81 | |
67 | |
63 | |
54 |
User | Count |
---|---|
120 | |
99 | |
91 | |
83 | |
65 |