Display historical data in same graph with forecasted data

[Anonymous]

Hi,

I have two tabels in PBI, one having historical data up untill the current day (Daily data) and then I have a another table with forecasted data, which is based on monthy forecasts. Is it possible to display both of them in the same graph?

Hope you can help.

[Anonymous]

Hi @Anonymous ,

Please have a try.

You can add a column to mark whether it is expected or forecasted, and then create a conditional format to highlight the forecasted data.

To write the data like Sep-22e, Dec-22e, you might can do something with calculation group.

Best Regards

Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi,

Unfortunately, its not the solution. 

I have to seperat tables, one containing daily data and one containing monthly data. The one with daily data is a historical view and the other one is a forecast. I would like to plot both in the graph, so I can have compare them 

[amitchandak]

@Anonymous , Refer this blog on the same topic, if that can help

Distributing/Allocating the Monthly Target(Convert to Daily Target): Measure ( Daily/MTD): https://community.powerbi.com/t5/Community-Blog/Power-BI-Distributing-Allocating-the-Monthly-Target-Convert-to/ba-p/1657798