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 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-msft's avatar
    v-juanli-msft
    Community 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

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable

      Thanks ,

      sorted

  • Anonymous's avatar
    Anonymous
    Not applicable

    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

      this is where I cant unselect order

      • Anonymous's avatar
        Anonymous
        Not 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