Forum Discussion
Categorical x-axis order problem
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
Sorry maybe you missed a part I said, I want to "unselect" it from this option, it is not the pbix I am worry about , I simply want to unselect this option, I dont want to order from this option because I have ordered it from data table,
Well, I think there is no option avilable for that as said in this discussion.
I invite you to remove the and re-add the column in your visual.
CR
Thanks , I have added a new chart and used the column but still shows the order there, I have removed the column and added again but still the same and order shows on the option list :(
ok, let me ask you another question => you want to unselect the order to sort on another column ? Anyway, a table will always be ordered so you may apply the sort on another column ?
Sorry, I don't get better answer because, when I personnaly want to come back to a privous order, it means I want to sort the data on another column, so I apply the sort on a different column.
CR
yes , how ever the coloumn that I want to order is not in the chart so it wont appear in the option list ,
this is where I have ordered it, but it ignores it, I know that for some other chart the order in option list not selected just cant do the same even though I created a new chart all together