Forum Discussion
Advocate IThe column chart does not display all the x-axis values
How can I display all the year labels on the x-axis? Currently, they’re only showing intermittently.
Thank you!
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.
Hello Gems
use this option showin in image
Thanks,
Pankaj Namekar | LinkedInIf this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.
3 Replies
- pankajnamekar25
Super User
Hello Gems
use this option showin in image
Thanks,
Pankaj Namekar | LinkedInIf this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.
- BhavinVyas3003
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.
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. 😞
