Does anyone have a workaround for null suppression in a waterfall graph?

[ClemensB]

In SAP Analytics Cloud I want to remove measures from a waterfall that are null. Given filtering on e.g. profit centers, a measure might end up being null and if the filter changes, the measure might take on a positive or negative value and should then be included again.

Datasource is a SAP Datasphere Analytical Model.

Does anyone have a workaround for null suppression in a waterfall graph? As per KBA 3150383 this is not available even though it is possible to enable zero suppression (which does not seem to work either, see screen shots). A couple of screen shots has been attached for context. 

SAC table of datasource without zero or null suppression.

Same table WITH zero and null suppression. All ok.

Waterfall WITH zero suppression. I want to get rid of the highlighted elements. For some reason, Consulting Fee Recovery is not removed with zero suppression.

Thanks for your help.

 

[GiriRaaj]

Hi ,

could you try the below shown option, if its a classic story:

If its a Optimized story :  follow the below option.

Hope it helps.

Regards

Giri

PSCC