Visualise future data with bar chart

[Anonymous]

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 

[v-stephen-msft · Accepted solution]

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

Forecasting in Power BI. A visual step-by-step guide to… | by Ednalyn C. De Dios | Towards Data Science

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.