Forum Discussion
Line and Clustered Column Chart cannot display the full year range in the X-axis
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
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.
Hi JorgeAbiad ,
Change your X-axis in format pane from Continuous scale type to Categorical scale type.
Thanks.
4 Replies
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.
Hi JorgeAbiad ,
Change your X-axis in format pane from Continuous scale type to Categorical scale type.
Thanks.
Hello Pragati11 ,
Thank you!! After applying ascending sort, I got what I want to achieved.
Regards,
JorgeAbiad
