How to remove blank values from dot chart

Options
LouiseBourgonjon
LouiseBourgonjon Member, ALL USERS, Partner, Certified Model Builder Posts: 5 Frequent Contributor
in Anaplan Community

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!

Tagged:

Comments

  • ankit_cheeni
    ankit_cheeni Member, ALL USERS, GroupMember, Partner, Certified Model Builder Posts: 5

    Hi @LouiseBourgonjon 

     

    @ryan_kohn  explained this in a detailed answer some time back. Check his response here and see if it helps.

     

  • LouiseBourgonjon
    LouiseBourgonjon Member, ALL USERS, Partner, Certified Model Builder Posts: 5 Frequent Contributor

    Thank you for your quick reply. That worked.

    However, it would be nice if "hide zeroes" would become a standard chart setting in Anaplan UX. That would avoid this workaround with line items and other modules.

  • LouiseBourgonjon
    LouiseBourgonjon Member, ALL USERS, Partner, Certified Model Builder Posts: 5 Frequent Contributor

    Thank you, I kudoed both ideas 🙂

Categories