Show column even if value is blank

[gusly]

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 categories without any values are hidden by default and there seems to be no easy way to prevent it from happening.

Is there a good solution for this?

[gusly]

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 · Accepted solution]

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.

[Mariam]

Unable to find that option in my report .

Can you share a screenshot where that option is visible?

[Mariam]

I am unable to find that option in my report. 

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

[Mariam]

I am unable to find that option in my report.

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

[Anonymous]

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]

You are the best 🙂

[gusly]

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