Display historical data in same graph with forecasted data

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

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 

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.