Sorting chart x-axis by Feet and Inches

[Anonymous]

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 

[v-yulgu-msft · Accepted solution]

Hi @Anonymous,

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

Best regards,

Yuliana Gu

[Anonymous]

@v-yulgu-msft

Thank you this worked perfectly.

[AlB]

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]

@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]

@Anonymous

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

[Anonymous]

@AlB

This is the index I am using and the order is still displayed incorrectly.

[AlB]

@Anonymous

Have you used the 'Sort by Column' feature in the Modelling pane?