Gap in a Stacked Area Chart with hourly data

[lehikk]

Please see the illustration below. The Stacked Area Chart show historical data up to certain date/time and some hours of forecasted data after that. The data is hourly and I have a (hourly) calendar table to which the data table is connected to.

Is there any way to make the chart appear visually continuous without the gap? In this case, the newest row of historical data is at 08:00 and the first row of forecast is at 09:00. If the datetimes on the data overlaps, the data at the "connection point" gets stacked which looks even worse and throws off the scale of the chart (the lower chart in the example). You can kinda' solve the problem if the historical data stops at let's say 08:00 and forecast starts at 08:01 (or 08:30) but it is more or less inconvenient as it affects filtering and also the charts appear visually different in the PBI Desktop and PBI Service versions (either one might show the charts overlapping a bit, even though it doesn't get stacked, but look weird still).

It would be nice to be able to exclude certain data series from Stacking and let it overlap if that's the case.

[v-yangliu-msft]

Hi  @lehikk ,

Visualization pane of a stacked column chart in Power Bi Desktop, with the type of the X axis set to Categorical.

This is the related document, you can view this content:

https://community.powerbi.com/t5/Desktop/stacked-area-chart-distorted-can-we-treat-blank-as-0/m-p/34...

https://community.powerbi.com/t5/Desktop/blank-space-in-middle-of-stacked-bar-chart/m-p/576994

https://community.powerbi.com/t5/Desktop/No-Data-showing-Gap-in-line-chart/m-p/826411

Best Regards,

Liu Yang

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