My chart has the dimension 'Sub region' and three expressions for active accounts,seats and Demo. The chart looks like the one below:
However, I want the chart to look like:
How can I achieve this? Thanks!
There are a couple of places you can try to fix that.
Either on the dimension tab check the checkbox that says Suppress When Value is Null.
Or on the Presentation tab, Suppress Zero-Values and/or Suppress Missing.