X axis doenst show all values

[Anonymous]

Hello everyone,

I've a issue with my grouped column diagram.

First of all the diagram didnt show all values of the lines. I have made adjustment in the visual to have a 100% coverage. Thats fixed.

But im still having problems with my X axis. it doesnt show all values and the diagram doenst look nice now.

the x axis goes per 2 instead of per 1.

like this 2 4 6 8 10

It has to be 1 2 3 4 5 6 7 9 10

Someone experienced the same issue?

Any help i appreciate

Peter

[v-piga-msft · Accepted solution]

Hi @Anonymous ,

For your scenario, I think that is the standard behavior for the charts.

By my tests, if you have each value for the value of X axis, you could achieve that by increasing the width of your chart, which works like below.

In addition, you could try to change the type of X axis to be Categorical as a workaround.

If that cannot achieve your desired output, I'm afraid that you'd better post your idea in power bi ideas forum and add your comments there to improve Power BI and make this feature coming sooner.

Best  Regards,

Cherry

[v-piga-msft · Accepted solution]

Hi @Anonymous ,

For your scenario, I think that is the standard behavior for the charts.

By my tests, if you have each value for the value of X axis, you could achieve that by increasing the width of your chart, which works like below.

In addition, you could try to change the type of X axis to be Categorical as a workaround.

If that cannot achieve your desired output, I'm afraid that you'd better post your idea in power bi ideas forum and add your comments there to improve Power BI and make this feature coming sooner.

Best  Regards,

Cherry

[Anonymous · Accepted solution]

@v-piga-msft  That did the trick.

i made the adjustments on the visual X axis and sort column and sort ascending/descending