The column chart does not display all the x-axis values

[Gems]

How can I display all the year labels on the x-axis? Currently, they’re only showing intermittently.
Thank you!

[BhavinVyas3003 · Accepted solution]

Select the Chart – Click on the column chart where year labels are missing.

In the Visualizations pane, go to the Format pane.

Expand the X-Axis section.

Scroll down to "Type" or "Concatenate labels":

• If you see Type, set it to Categorical instead of "Continuous.
• If you see Concatenate labels, set it to Off.

Check the "Maximum size" or "Inner padding":

• Reduce inner padding to make space for all labels.

Turn "Word wrap" On (optional) to avoid overlap if labels are long.

[J_KNIGHT_0613]

The problem is that if you want to show a trend line, you have to use "Continuous" which then not only shows labels under certain bars, but they are not necessarily under the right bar - so maddening!  I cannot upload the screenshot for some reason, but I am showing a rolling 12 calendar months.  It has January 2026 under the December column of the chart.  I've tried to use Year and Month from the Date Hierarchy, separate Year and Month fields, etc. - nothing works when you want to have a trend line. 😞

[pankajnamekar25 · Accepted solution]

Hello @Gems 

use this option showin in image

Thanks,
 Pankaj Namekar | LinkedIn

If this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.

[BhavinVyas3003 · Accepted solution]

Select the Chart – Click on the column chart where year labels are missing.

In the Visualizations pane, go to the Format pane.

Expand the X-Axis section.

Scroll down to "Type" or "Concatenate labels":

• If you see Type, set it to Categorical instead of "Continuous.
• If you see Concatenate labels, set it to Off.

Check the "Maximum size" or "Inner padding":

• Reduce inner padding to make space for all labels.

Turn "Word wrap" On (optional) to avoid overlap if labels are long.