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.
In a line graph, through the Analytics pane, you can create a forecast line along with a confidence interval that will result in not only a line being created to project out a forecast but also a kind of funnel that will show you where the future values are likely to fall based on the confidence interval you set. If you hover over this line on the chart it will show you not only the forecasted value but also the upper and lower bound of the confidence interval. I would like to be able to display these projections on a card object. Is there anyway using DAX or otherwise to capture or reproduce the forecast and bounds displayed in the chart when you hover over it? Is there a DAX function that represents what Power BI is doing to create these forecasts? If there is, that could be used to essentially recreate these numbers. My understanding is that Microsoft does not make available the exact statistical models it uses to create these forecasts but I was hoping that maybe they have some function in DAX that could be used to calculate forecasts the same way that the forecasting feature under the Anaytics pane for the line graphs can do it.
I wrote an article on correlation and forecasting a long time ago here:
Eventually that made it to this Quick Measure in the gallery:
Might get you closer to what you are looking for.
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 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
101 | |
86 | |
64 |