How to remove blank values from dot chart


Hi Anaplan Community,


I would like to get rid of dots in dot charts that stand for blank or zero values.

Initially I thought I had to change the number format to blank for zero values (instead of zero), because that had done the trick for the bar chart, but this does not seem to work for the dot chart type. Any workaround here?


See picture attached of the graph and the module. You will see that for the blue forecast bars the bars nor the data label shows but for the red dots, the dots shows up.


thank you!