Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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 or...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    7 years ago

    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

     

     

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi Anonymous,

 

Could you please make a print screen or share your PBIX file ?

Will be easiir to help you !

 

Regards,

CR

Anonymous's avatar
Anonymous
Not applicable
7 years ago

this is where I cant unselect order

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    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

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      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,

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        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