X-axis labels are displaced!?

[aritrareyan]

I don't understand what I did wrong. I fiddled with all the options in x-axis but can't fix it. Help?

[v-yangliu-msft]

Hi  @aritrareyan ,

You can try:

Format of Visual--X Axis--Type

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[aj1973]

Ok I understand, Try going by elimination rule, meaning, in Power query filter your rows in opposed to the Column in question and each time you filter a set of row see if the visual gets corrected. Do it until you catch the wrong row that is causing the problem.

Sorry I am doing my best by speculating on a solution because i don't have clear vision on your data source.

Good Luck

[aj1973]

Hi,

Go back to Power query and try to Trim the column where you have those lables. It looks like you have unwanted spaces in that column.

[aritrareyan]

It didn't work. 😞

[aj1973]

Can you share a sample of your PBIX? or maybe the data source!

[aritrareyan]

Sorry, can't do that. Data is kind of sensitive. This never happened to me before. I cleaned and trimmed the data in all tables. Changed the column type into text. Cleaned, trimmed and then reverted back into the original type. Nothing happened. I'm totally stumped on this. You are right though, there is something wrong in the columns or in the query.