Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Custom sort of Matrix rows

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

 

Humandoing_0-1621930566945.png

 

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.

 

Humandoing_1-1621930621252.png

 

1 ACCEPTED SOLUTION
v-luwang-msft
Community Support
Community Support

Hi  @Anonymous ,

Base data:

v-luwang-msft_0-1622105149569.png

Sort number table:

v-luwang-msft_1-1622105193375.pngv-luwang-msft_2-1622105216755.png

 

Relationship:

v-luwang-msft_3-1622105235630.png

 

And final visulization:

v-luwang-msft_4-1622105283566.png

 

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

 

 

Best Regards

Lucien

View solution in original post

5 REPLIES 5
Paulina_Przybyl
Regular Visitor

I have exacly the same problem 😞

v-luwang-msft
Community Support
Community Support

Hi  @Anonymous ,

Base data:

v-luwang-msft_0-1622105149569.png

Sort number table:

v-luwang-msft_1-1622105193375.pngv-luwang-msft_2-1622105216755.png

 

Relationship:

v-luwang-msft_3-1622105235630.png

 

And final visulization:

v-luwang-msft_4-1622105283566.png

 

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

 

 

Best Regards

Lucien

Anonymous
Not applicable

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

amitchandak
Super User
Super User

@Anonymous , Have marked index as sort column for LTLA

 

Sortnewribbion.png

Anonymous
Not applicable

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.

 

Humandoing_0-1621934771363.png

 

However when I put LTLA in it reverts to sorting alphabetically

 

Humandoing_1-1621934832853.png

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

 

Humandoing_2-1621934877980.png

 

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.