Remove Specific Value from Bottom Axis

Dashboard Designer SharePoint 2013/2016, Office 365 versions
1

I would like to remove one of the values from my bottom axis of my bar chart. I've removed the nulls but I would like to remove the 'N/A' value. My setup is similar to what was posted in the link below.

Thank you

3

Have you tried to add this

#= value != 0 ? value: ' ' #

image

1 Like
4

Maybe something like this works for you?

#= value != "N/A" ? value: ' ' #

Didn’t really have a way of testing it.

5

And this might work to hide both zero values and N/A
#if (value == 0 || value == "N/A") {# #=' '# #} else {# #=value# #}#