cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Moc7h2 Frequent Visitor
Frequent Visitor

Sorting rules for filtered results in reports

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?

 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Sorting rules for filtered results in reports

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

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
3 REPLIES 3
Community Support Team
Community Support Team

Re: Sorting rules for filtered results in reports

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

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
Moc7h2 Frequent Visitor
Frequent Visitor

Re: Sorting rules for filtered results in reports

Thanks xiaoxin, so to clarify, it will sort all 400 original results, and not just the 100 that have been displayed to the user?
Community Support Team
Community Support Team

Re: Sorting rules for filtered results in reports

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

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |