Sort

[gladies123]

Hi Team,

Kindly let me know the idea to sort the Top15 and Others . "Others" to displayed at the last i have attached an image for your reference

Output should be displayed as below image

Thanks,

gladis

[Anonymous · Accepted solution]

Hi @gladies123,

I think you can try to add a calculated column to your table to rank and remark your records. You can add if statement on it to filter the rank if it is large than 15 and replace them as others. (rank <= 15, return 'original category name', rank > 15, return 'others')

If the above does not help, can you please share a pbix or some dummy data that keep raw data structure with expected results? they will help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng

[amitchandak]

@gladies123 , For TOPN +others you can refer this

 - https://www.youtube.com/watch?v=UAnylK9bm1I

For other to be at bottom, you need create a sort order and mark that the sort column