Forum Discussion
Display historical data in same graph with forecasted data
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 poss...
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.