Display Bar Chart Columns with Value of 0

[User398360]

In a report bar chart, is it possible to display all values on the X-axis, even those with a value of 0? Right now, only the bar columns with a value > 0 are displaying.

[PaulSylo]

Can you share the screenshot of the barchart report once?

[PaulSylo]

We will be using bar chart type to compare individual or aggregate scores across single data dimensions. it is not possible to represent the zero, as the value will not be available in that single dimension to capture in the table (starting value will be 1, No 0 will not be displayed or no data for that),

but if you see in multidimensional reports like bubble, multilevel pivot, or heatmap, you can display zero, as we have one of dimension field may be empty without any value and other fields have one. so it is possible in that multidimensional table reports.

to conclude, it is not possible to bring zero value in x-axis in barchart!

[Brian Lancaster]

I don't think there is configuration for 0 in a bar chart. However, if you can convert it to a multi-level pivot report there is configuration to show 0.

[shloke04]

Hi,

Can you please explain when you say 0 is not displayed as one of the bar columns what is the use case you are trying to achieve?

It will depend on the type of field on which you are trying to report on , say if it is an Integer Type field then it will shown up when you group it by that field as for example shown below:

But just want to understand to help you that when you say Zero are you saying that there are no records for that criteria?

Hope this helps. Please mark the answer as correct/helpful based on impact.

Regards,
Shloke