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,
I have a query about column sort rules. - If i have a report which, on filter, returns 400 resuts, of which the first 100 are visually dsplayed to the user. The results are sorted on column X. The user then wants to sort the results by Column Y, Will Column Y sort on only the 100 visualy returned results, or will it sort on all 400 from the original filter?
Solved! Go to Solution.
HI @Moc7h2,
>>Thanks xiaoxin, so to clarify, it will sort all 400 original results, and not just the 100 that have been displayed to the user?
In fact, you can add allselected function on table to rank filtered records. I mean it is hard to use rankx function to sorting for multiple columns.
Regards,
Xiaoxin Sheng
Hi @Moc7h2,
It will ignore original sort effect and use column Y to sorting your records.(power bi not support sort by multiple columns)
Regards,
Xiaoxin Sheng
HI @Moc7h2,
>>Thanks xiaoxin, so to clarify, it will sort all 400 original results, and not just the 100 that have been displayed to the user?
In fact, you can add allselected function on table to rank filtered records. I mean it is hard to use rankx function to sorting for multiple columns.
Regards,
Xiaoxin Sheng
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 |
---|---|
113 | |
97 | |
79 | |
73 | |
56 |
User | Count |
---|---|
145 | |
105 | |
104 | |
90 | |
63 |