Forum Discussion
Categorical x-axis order problem
Hi ,
I know the similar question has been asked and answered a few times but my problem is a little different
I have a chart that I am using category for axis, and on powerBI data table i have ordered by order column but chart is not ordering it by "order " column,
I have noticed on the chart on more option "sort Descending" is selected and what ever I do I cant get sorting unselected from more option window, any advice,
Hi Anonymous
It seems you need to sort [category] column in axis based on another column (which column doesn't exsit in this chart).
To workaround this, clcik on that [category] column, then select "sort by column"->"order"
Best Reagrds
Maggie
12 Replies
- v-juanli-msftCommunity Support
Hi Anonymous
It seems you need to sort [category] column in axis based on another column (which column doesn't exsit in this chart).
To workaround this, clcik on that [category] column, then select "sort by column"->"order"
Best Reagrds
Maggie
- AnonymousNot applicable
Thanks ,
sorted
- AnonymousNot applicable
Hi Anonymous,
Could you please make a print screen or share your PBIX file ?
Will be easiir to help you !
Regards,
CR
- AnonymousNot applicable
this is where I cant unselect order
- AnonymousNot applicable
I don't catch you because I use to click on Sort By then on Sort Descending or Ascending.
And if want to change the sort, I click again on Sort By.
lease share you PBIX on dropbox ! Better to solve it reapidly
CR