Forum Discussion

gusly's avatar
gusly
Icon for Helper II rankHelper II
10 years ago
Solved

Show column even if value is blank

I'm using a categorical x-axis for a simple column chart. In this case, it's important for me to always show all categories - to show those categories with blank (or 0 value). The problem is that the...
Need Help
  • austinsense's avatar
    austinsense
    10 years ago
    I think there's an option on the visualization options to "show values with no data" I'm on my phone or I'd try to show a screenshot.
gusly's avatar
gusly
Icon for Helper II rankHelper II
10 years ago

A workaround I just found was to create a Measure that returns 0 if blank for the value, like this:  

IF(ISBLANK(value); 0; value) 

 However, the same method does not seem to work for regular/calculated columns.

Please let me know if there are other ways though.

  • austinsense's avatar
    austinsense
    Icon for Impactful Individual rankImpactful Individual
    10 years ago
    I think there's an option on the visualization options to "show values with no data" I'm on my phone or I'd try to show a screenshot.
    • gusly's avatar
      gusly
      Icon for Helper II rankHelper II
      10 years ago

      Ah, I had totally missed that option. Exactly what I was looking for, thank you!

    • Mariam's avatar
      Mariam
      New Member
      8 years ago

      I am unable to find that option in my report.

      Can you please share with me the screenshot where the option is available?

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        On the visualisations pane, once a field is dropped into the axis section there is a small downwards arrow. Click this and the option is near the bottom of that list. 

    • Mariam's avatar
      Mariam
      New Member
      8 years ago

      I am unable to find that option in my report. 

      Can you please share with me the screenshot where that option is visible?