Why Bar Size Reduced in Bold BI Charts

When adding a field into the row section of a chart in Bold BI, the bar size may be reduced. This can be confusing and may not provide the desired visualization.

Cause

The bar size reduction is caused by empty points created in the chart due to the same field being configured in both the Row and Column sections. This results in empty spaces being occupied by points with null (0) values.

Solution

To avoid this issue, do not configure the same values in both the Row and Column sections. Instead, consider what you are trying to achieve with the chart and configure the fields accordingly.

In general, the field configured in the Row creates a series of bar based on the row data count, and while configuring the same field to both Column and Row, the empty points are created for the Columns which are not available in the Row.

For example, if you have an Excel sheet like below with missing data for a India in 2022 , the chart will display a gap by default. However, you can change the mode to Average or Zero to fill in the empty space.

In conclusion, this is a behavior of the chart in Bold BI. If you don’t want empty spaces, you can change the mode as per your needs.