topic Re: Sorting in Matrix in Desktop

Sorting in Matrix

mrothschild — Mon, 25 Nov 2019 18:18:42 GMT

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

[Title] is sorted by [Title Rank] under the Modeling window. In the Table it's sorting properly, but in the Matrix it's sorting alphabetically. You can see both are sorted by [Title]

Any suggestions to get the Matrix to sort as intended?

Thanks!

Re: Sorting in Matrix

parry2k — Mon, 25 Nov 2019 19:23:35 GMT

mrothschild did you put the Title in rows or in value section of matrix?

Re: Sorting in Matrix

mrothschild — Mon, 25 Nov 2019 19:41:02 GMT

Title is in the Values section.

Re: Sorting in Matrix

v-xicai — Tue, 26 Nov 2019 09:57:35 GMT

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.

Re: Sorting in Matrix

mrothschild — Tue, 26 Nov 2019 16:49:24 GMT

Hi v-xicai

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