Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Sorting chart x-axis by Feet and Inches

Hi,

 

I am having trouble sorting the x axis by human height.

 

 

I have indexed the table but the visualisation displays it in the wrong order.

 

Is there a way to sort this, preferably keeping the visualisation in feet and inches rather than meters.

 

Thanks in advance 

 

 

Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    7 years ago

    Hi Anonymous,

     

    In data view, you should change the sort by option from the default setting to "Height Index".

     

    Best regards,

    Yuliana Gu

7 Replies

  • AlB's avatar
    AlB
    Community Champion
    7 years ago

    Hi Anonymous

     

    What do you mean in the wrong order? Do you want the 7-6 to appear the first on the left instead?

    Have you tried to sort by Height and descending on the visual? 

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      AlB

       

      The graph displays 5-10 5-11 5-9 6-0 6-1 6-10 6-11 6-2

       

      I would like it to display 5-9 5-10 5-11 6-0 6-1 etc in a actual height order.

       

      I have tried sorting by height and descending and this is what happens.

       

       

      • AlB's avatar
        AlB
        Community Champion
        7 years ago

        Anonymous

        I see. Then you need to update the Height Index to reflect that sorting

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee
    7 years ago

    Hi Anonymous,

     

    In data view, you should change the sort by option from the default setting to "Height Index".

     

    Best regards,

    Yuliana Gu