Help with stacked column chart and x-axis values

[rjspereira]

Hi,

I have this chart, when i have year as my x-axis, it's not showing all the years, as you can see in this image:

The same chart with, for instance month as x-axis, already shows all the values:

Is this some bug or some strange behaviour? Please how can i change some setting to always show all the values in the x-axis.

Thanks.

[rjspereira]

There is any way to load this chart when it as many x values, to show the scroll bar all to the right side as the image:

Because by default, the scroll is at the left side and to see the latest months as in the images, the user as to manual slide from left to right.

[gadielsolis · Accepted solution]

Hello,

Please go to Visual>X-Axis and change the type to "Categorical".

When you use continuous usually Power BI summarize the axis values.