DAX

[giress]

Good day,

Please could anyone be of assistance:

I have a CSV file with 2 columns "alt_bpart_id" and "bpart_id" both with non-unique values. I want to group by column "bpart_id" and then sort. The result should show both columns, of which column "bpart_id" will have distinct values (as it would have grouped all values in column "alt_bpart_id"). I have tried ChatGPT but am not winning.

Thank you.

[Anonymous · Accepted solution]

HI @giress,

In power bi data model table does not support sorting by multiple report pages, you can take a look at the following link about sorting multiple columns in power bi.

Solved: Sorting by multiple columns - Microsoft Fabric Community

Regards,

Xiaoxin Sheng