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.
I'm trying to show the average for the last 90 days as a straight line on the chart, but I only get a moving average. Do you have any ideas how this can be done in a straight line? I will be grateful for any help.
Solved! Go to Solution.
Hi @Datanik,
Calculate average for the entire duration that you want and ignore any filter context in that measure. Then add a constant line in your visual from the Analytics Pane by using that measure.
Did I answer your question? Mark this post as a solution if I did!
Consider taking a look at my blog: Forecast Period - Previous Forecasts
Hi @Datanik,
Calculate average for the entire duration that you want and ignore any filter context in that measure. Then add a constant line in your visual from the Analytics Pane by using that measure.
Did I answer your question? Mark this post as a solution if I did!
Consider taking a look at my blog: Forecast Period - Previous Forecasts
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 |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |