Forum Discussion

Continued Contributor

6 years ago

Sorting in Matrix

Hi, In the attached screenshot, I have a Table and a Matrix visual. The data is: First Name Title Title Rank Matt CEO 2 Adam Chairman 1 Russell Managing Director 3 ...

Community Support

6 years ago

Hi mrothschild ,

Based on testing in the latest version 2.75.5649.861 of Power BI Desktop, I can sort the [Title] by the [Title Rank] in Matrix visual successfully. You may update the Power BI Desktop to the latest version, and try it again.

Best Regards,

Amy

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Continued Contributor

6 years ago

I've attached a PBIX file that I believe mirrors yours. I have updated my version to: Version: 2.75.5649.861 64-bit (November 2019)

https://drive.google.com/file/d/1rjW6KJdzB1FHjEohIDwZHAvd5ZGqYYX3/view?usp=sharing

When I sort by the column header "First Title" the order is either:

(1) CEO, (2) Chairman, (3) Managing Director, or

(3) CEO, (2) Chairman, (1) Managing Director

I cannot get it to sort by title rank, which is

(1) Chairman, (2) CEO, or (3) Managing Director even though Title is sorted by Title Rank