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
vjnvinod
Impactful Individual
Impactful Individual

Ranking

Hi Team,

 

Below is my table matrix, i would like to rank it which means Partner/Principal should come on top and so

 

rankindexing.PNG

1 ACCEPTED SOLUTION

select table and rank column from table field..then check it will show.

 

Greyout option is a default, manually try. I know this a bit weird but try. 

View solution in original post

4 REPLIES 4
adityavighne
Continued Contributor
Continued Contributor

Create a column with an index (1,2,3,4..) for rank from your data.

then in this below table, you can sort rank by index.

 

Rank.PNG

 

@adityavighne 

 

i already have the rank created, but not sure where do i drag that in my table and i also noticed that the sort option which you showed seems to be freezed for me , take a look at the below snap

 

indexingnewquery.PNG

select table and rank column from table field..then check it will show.

 

Greyout option is a default, manually try. I know this a bit weird but try. 

@adityavighne 

 

got it, thanks.

this is really weird though, looks bit tricy while selecting both parallely

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.