Custom sort of Matrix rows

[Anonymous]

Hi everyone, I am trying to sort some areas in a Matrix table so it looks like the below

I was thinking by creating a table sorted by index and creating a relationship between LTLA in this table ( and LTLA in my fact table, the matrix would sort in the above order. How it sorts like below (i.e. alphabetical) - can anyone advise please? Thank you.

[Paulina_Przybyl]

I have exacly the same problem 😞

[v-luwang-msft · Accepted solution]

Hi  @Anonymous ，

Base data:

Sort number table:

Relationship:

And final visulization:

Is this what you want? Wish it is helpful for you!

Best Regards

Lucien

[Anonymous]

@amitchandak Are you able to help with this further please Sir?

[amitchandak]

@Anonymous , Have marked index as sort column for LTLA

[Anonymous]

Thanks, I have done the sort by column but it still doesn't seem to work. If I drop 'index' in to the rows field of the visualisation I do get 1-6.

However when I put LTLA in it reverts to sorting alphabetically

Table is set up like below, are you able to advise further please?