Sorting rules for filtered results in reports

[Moc7h2]

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?

[v-shex-msft]

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

[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?

[v-shex-msft · Accepted 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