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. 

      • jondufault's avatar
        jondufault
        Frequent Visitor
        2 years ago

        You are the best 🙂

  • 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?

  • Mariam's avatar
    Mariam
    New Member
    8 years ago

    Unable to find that option in my report .

    Can you share a screenshot where that option is visible?