QUESTION::MATRIX VISUAL::SORT BY

[Element115]

PBID Version: 2.128.1380.0 64-bit (April 2024)

A couple year old report opened with the above version of PBID allows me to sort a Matrix visual by more than one row field, like so:

So why is it, still using the same PBID version, when I create a new Matrix in a different report, now I can only select one row field, and not more than one?

Has something changed, or is there a glitch in the matrix (pun intended!, it's the end of a long day) 😎?

[v-yangliu-msft · Accepted solution]

Hi  @Element115 ,

Using the left mouse button, click on the Row field and it will be sorted by the hierarchical field that was expanded before you clicked on it to display the following:

If you want to display multiple columns sorted in table visual, you need Shift + left mouse button.

Solved: Matrix multiple Sort columns - Microsoft Fabric Community

Best Regards,

Liu Yang

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

[Element115]

Ah right!  Sorry, mut have been too tired that day. For some reason I thought we could do it from the contextual menu.