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