Showing historical and forecasted data in the same chart

[Anonymous]

How to add e (expected) or f (forecasted) with years in a chart (like 4Q22e, 2023e) such that date format is retained (i.e. it does not change into text format)..Basically, I want to show both the historical and forecasted data in the same chart. Thanks

[v-angzheng-msft]

Hi, @Anonymous 

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.

Refer to the content of the calculation group in this thread may be useful to you

https://community.powerbi.com/t5/Desktop/How-to-display-Text-values-on-Bar-chart/td-p/1947916/page/2

Best Regards,
Community Support Team _ Zeon Zheng

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

[Anonymous]

Hi, @amitchandak, This table has both historical data (Mar-19 to Sep 21) and forecasted data (Dec-21 to Dec-22)..I want to show the data on a single chart and highlight to the user that these particular data points are forecasted values (by dotted line or 4Q21e, etc.). I simply can't write Sep-22e, Dec-22e as I don't want the format to be changed to text (from date) as the data slider wont appear then. Thanks

Date	World production	World consumption
Mar-19	100.24	100.14
Jun-19	100.43	100.69
Sep-19	100.22	102.10
Dec-19	101.77	101.64
Mar-20	100.74	95.83
Jun-20	92.30	84.90
Sep-20	91.02	93.47
Dec-20	92.75	95.43
Mar-21	92.80	94.66
Jun-21	94.76	96.67
Sep-21	96.64	98.52
Dec-21	99.15	99.98
Mar-22	99.75	99.84
Jun-22	101.04	100.57
Sep-22	102.00	101.67
Dec-22	102.45	101.70

[amitchandak]

@Anonymous ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.