Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
105 | |
79 | |
69 | |
62 |
User | Count |
---|---|
142 | |
105 | |
103 | |
85 | |
70 |