Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to 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.
@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.
When I click on my slicer I don't have those options to sort by.
User | Count |
---|---|
107 | |
87 | |
81 | |
76 | |
71 |
User | Count |
---|---|
112 | |
105 | |
96 | |
74 | |
66 |