Improving Stacked Area Charts

[Bricominer]

🚨🚨🚨 FEATURE REQUEST — HIGH PRIORITY 🚨🚨🚨

👉👉 ADD A "FILL SERIES GAPS" OPTION TO STACKED AREA/STACKED BAR CHARTS 👈👈

(Power BI Visualization Engine)

📣 This is a CRITICAL request for stacked visuals with cumulative data. 📣

Power BI stacked area and stacked column visuals currently break when:

• series have missing dates

• categories appear/disappear

• cumulative series cross each other

• not all series have values at every axis point

This causes:

• gaps between layers

• overlapping filled areas

• jagged broken shapes

• incorrect stacking geometry

• unreadable charts

➡️ The math is correct — the VISUALIZATION ENGINE is the problem.
➡️ Users have no way to fix this without rewriting their data model.

---

💡 The FIX is extremely simple:

✔️ Add an option: “Fill Missing Series Values (Forward Fill)”

(or “Interpolate Gaps”, “Connect Series Across Gaps”, etc.)

This option would:

• forward-fill each category's last known value

• maintain consistent stacking order

• prevent polygon breaks

• allow cumulative stacked charts to work correctly

• prevent layers from collapsing or overlapping

Other visualization libraries (Plotly, D3, Matplotlib) support this via:

• connectgaps = true

• stackgap = "interpolate"

• stackorder = fixed

Power BI needs the same capability.

---

🧨 URGENCY

This limitation impacts:

• cumulative metrics

• event sequence charts

• inventory tracking

• backlog burn-up charts

• multi-category growth trends

• forecasting overlays

Every enterprise dashboard team runs into this.

---

🗳️ Please prioritize this 🙏🔥

It’s a tiny UI feature that unlocks a massive number of scenarios Power BI users currently cannot visualize correctly.

👉👉 Please add “Fill series gaps” to stacked visuals! 👈👈
👉👉 This should be a top-priority enhancement! 👈👈
👉👉 Thousands of users will benefit immediately! 👈👈

🔥 Thanks Power BI team — this one change would massively improve the product.