Line and Clustered Column Chart cannot display the full year range in the X-axis

[JorgeAbiad]

Hello PBI experts,

Good day!!

I have created a visualization using Line and Clustered Column chart. In the X-axis I plotted the Year value. The values in the X-axis is can be changed by using a Slicer visual. In the Slicer visual, the range is from 2020-2036. Currently, we only have data until 2030, However, if I would select the yea from 2020 up to 2030, only 2020,2022,2024,2026,2028,2030 are shown in the X-axis. The data for 2021,2023,2025,2027 and 2029 are shown but the years are not shown in the X-axis. Basically, I have here 11 years of data. I noticed that when the values in the X-axis exceed 10, the values in the X-axis is being cropped out. Is this standard behavior of this visual? Is there a possible way to display all 11 year values, considering that it will be expanded when we enter our data for 2031 - 2036?

Thank you!

Missing Year values

[MFelix · Accepted solution]

Hi @JorgeAbiad ,

Looking at you image appears to me that the axis is on continuos format check the x-axis format and try changing it to categorical instead of continuous.

[Pragati11 · Accepted solution]

Hi @JorgeAbiad ,

Change your X-axis in format pane from Continuous scale type to Categorical scale type.

Thanks.

[JorgeAbiad]

Hello @Pragati11 ,

Thank you!! After applying ascending sort, I got what I want to achieved.

Regards,

JorgeAbiad

[MFelix · Accepted solution]

Hi @JorgeAbiad ,

Looking at you image appears to me that the axis is on continuos format check the x-axis format and try changing it to categorical instead of continuous.

[JorgeAbiad]

Hello @MFelix ,

Thank you very much! This is just what I need.

Regards,

JorgeAbiad