Bar Chart hide 0 bar

[joanneyeung]

Hi all,

We have a report like attached, there are some bar with 0 items. Can we just simple hide those 0 items bars and not showing them in the bar chart?

Thank you.

Best Regards,

Joanne

[mike_bush]

A bar chart would not normally show a zero bar like this - can you give us more detail?

[joanneyeung]

Hi Mike,

We have created a integer field Job Unit in Incident table, and in this report, it is calculating the sum of Job Unit.

You can refer to the settings of the report.

[mike_bush · Accepted solution]

Aha - here there is a simple trick.

Filter on "Job Unit" > 0

[joanneyeung]

That works! Thank you Mike