Sorting a slicer by the sums of another column

[suchomelb]

Hi all! I am having a heck of a time finding out how to sort my slicer in order of highest to lowest of a sum in another column. I thought maybe if I was to give each one a rank and then sort by that rank it would essentially let me get the largest sums at the top and the smallest at the bottom of the list.

This is what I thought might work, but essentially if theres an easier way I just want the slicer example below to be in that order.

Name	Hours	Rank		Slicer Order
Joe	8	1		Joe
Sam	12	2		Sam
Bill	6	4		John
John	7	3		Bill
Kim	3	5		Kim
Sam	4	2
Joe	7	1
John	7	3
Joe	7	1
Joe	2	1
Kim	2	5
Joe	5	1

Thanks in advance for any and all help.

[HarishKM · Accepted solution]

@suchomelb  Hello ,
Then you can create a conditonal column in power query.
Give conditon like this..

Slicer Order	Sorting
Joe	1
Sam	2
Bill	3
John	4
Kim	5

Then go to data view after loading new data using close and apply button in power query . select your slicer column then use sort by column -> select your newly created sorting column.
and Also you can sort your column by asc and Dsc using slicer 3 dot menu.
it will fulfill your requirement.

[HarishKM]

@suchomelb Hello,
you can use this way to sort by anther column.

Thanks

Harish M

[suchomelb]

When I click on my slicer I don't have those options to sort by.