Forum Discussion
gusly
Helper II
Helper IIShow 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 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?
- 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.
8 Replies
guslyA 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
Impactful Individual
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
Ah, I had totally missed that option. Exactly what I was looking for, thank you!