3389611 - Chart Zero Suppression Not Working on a Story in SAP Analytics Cloud (SAC)

• Chart with zero suppression enabled still displays 0 values on a Story in SAP Analytics Cloud.

• SAP Analytics Cloud 2023.21

1. Open Story in SAP Analytics Cloud.
2. Enable "Zero Suppression" in a Chart properties.
3. Notice zero value measures still appear.

• Setting a measures decimal places to "0" during modeling acts only as number formatting.
• Increasing the decimal places to 3 will display that the previously "zero" values are small decimal values like "0.001".

• This behavior is by design.  Zero suppression is applied before any number formatting is done.  If a number is not an actual zero (e.g. 0.0005), it will not be suppressed regardless of the formatting settings in the model or chart.
     
• A workaround is to create a calculated measure or dimension which sets a value to zero if it is less than 0.5 or whatever your desired cutoff point is.

• Hiding Zeros in a Chart

SAC, graph, Zero suppression , KBA , LOD-ANA-DES , Story Design & Visualizations , Problem