Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi All,
I have a table like this, even after sorting in asc or desc I want alex will be in top always, how can we achieve this in power bi
Name | Mark |
Alex | 50 |
Praveen | 45 |
Santhosh | 60 |
Naveen | 70 |
Name | Mark |
Alex | 50 |
Naveen | 70 |
Santhosh | 60 |
Praveen | 45 |
Hi,
If you want to adjust such a sorting in Power Query, try adding a new column called "Priority" and then apply this solution - https://community.powerbi.com/t5/Desktop/Sorting-a-table-using-multiple-columns/m-p/447941
See a test case with your data:
Update:
If there is a limited amount of such VIP names in your table, the conditional column for sorting may look like:
*Don't forget to adjust the format so the output value is number, not text.
And then you just choose this newly created column as a column used for sorting Mark:
User | Count |
---|---|
124 | |
108 | |
99 | |
62 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |