Loading

How to Remove a Blank Space Within a Stacked Area Chart

Veröffentlichungsdatum: Feb 26, 2026
Aufgabe
When different categories are lined up on the same level of a stacked area chart, a blank space is created if there is no data between the different categories.

How to remove a blank space within a stacked area chart as shown here:
User-added image
Schritte
Since an area with no data between the different categories is NULL, we will change the default behavior for the NULL value to remove the unwanted blank space.  Please review the steps below and a sample workbook attached to this article in the far right column under "Attachments".
Change format of the measure. 
1. Right-click on Measure.
2. Choose Format.
3. Choose Pane > Special Values (e.g. NULL).
4. Select Show at default Value.
User-added image
Zusätzliche Ressourcen
The point of this solution is how NULL values are treated in certain cases where categories are missing. These NULL values are by default not plotted.  The data that crosses such a point cannot be connected by a line (or area).

Applying this solution may change the shape of the non-blank area. The shape can change because NULL is now calculated as zero, allowing graphs that were broken by nulls to be connected. The graphs are now drawn in a shape closer to the actual values.
Nummer des Knowledge-Artikels

001470680

Anhänge

stacked_area_chart.twbx

1239 KB

 
Laden
Salesforce Help | Article