Forum Discussion

aritrareyan's avatar
aritrareyan
Regular Visitor
5 years ago

X-axis labels are displaced!?

I don't understand what I did wrong. I fiddled with all the options in x-axis but can't fix it. Help?
Need Help
aj1973's avatar
aj1973
Icon for Community Champion rankCommunity Champion
5 years ago

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's avatar
aritrareyan
Regular Visitor
5 years ago

It didn't work. 😞

  • aj1973's avatar
    aj1973
    Icon for Community Champion rankCommunity Champion
    5 years ago

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

    • aritrareyan's avatar
      aritrareyan
      Regular Visitor
      5 years ago

      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.