Forum Discussion
Visualise future data with bar chart
Hi.
How do I visualize future data in a bar chart?
I have this chart with week number on the x-axis and hours on the y-axis. I would like to somehow visualise by either colors or something else future expected hours (e.g. in week 4, 8, 10, 12, 14 etc).
How do I do that or can I do it in another chart?
Best regards,
Lisa
Hi Anonymous ,
You may try the forecast line.
The forecasting feature utilizes built-in predictive forecasting models to automatically detect the step (monthly/weekly/annually) and seasonality in your data to provide forecasting results.
When you add a forecast line, you will have two sets of options available to configure. You can control the styling of the forecasting, similar to the controls you have for trend lines. You can also control settings specific to forecasting.
Use the Analytics pane in Power BI Desktop - Power BI | Microsoft Learn
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
Hi Anonymous ,
You may try the forecast line.
The forecasting feature utilizes built-in predictive forecasting models to automatically detect the step (monthly/weekly/annually) and seasonality in your data to provide forecasting results.
When you add a forecast line, you will have two sets of options available to configure. You can control the styling of the forecasting, similar to the controls you have for trend lines. You can also control settings specific to forecasting.
Use the Analytics pane in Power BI Desktop - Power BI | Microsoft Learn
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.