Power BI Matrix - Rows Sorting not working for all columns

[kc1988]

Dear Power BI Community,

I am having diffficulties of getting Power BI - Matrix Row Sorting working based on my requirements. I need to perform sorting on all the Rows value (year, counterparty, tier and marketcap)

Please look at the screnshot below for the Matrix that i created on power bi, along with the table relationship.

Sorting Behaviour observed:

1. I was able to get year and counterparty row value sorting (asc or desc) working 

2. However, i am not getting the right sorting results for tier and marketcap (see screenshot below)

• with descending order selected for tier, i am not seeing it in descending order.

• same goes for marketcap, i couldn't get the right ordering after sorting the row.

Do i need to enable any configuration in the matrix to properly sort the columns? What did i miss?

thanks all!

[danextian · Accepted solution]

Hi @kc1988 

Although your matrix appears similar to a table, the sorting behavior of row categories is different. Sorting is applied relative to the hierarchy level above, meaning marketcap is sorted within the context of the Year > Counterparty > Tier hierarchy. If you want the rows to be sorted by marketcap, move it to far left or the highest level in the hierarchy.

[v-pnaroju-msft]

Hi kc1988,

We are following up to see if your query has been resolved. Should you have identified a solution, we kindly request you to share it with the community to assist others facing similar issues.

Should you have any further queries, kindly feel free to contact the Microsoft Fabric community.

Thank you.

[v-pnaroju-msft]

Hi kc1988,

We wanted to check in regarding your query, as we have not heard back from you. If you have resolved the issue, sharing the solution with the community would be greatly appreciated and could help others encountering similar challenges.

If you found our response useful, kindly mark it as the accepted solution to guide other members.Should you have any further queries, kindly feel free to contact the Microsoft Fabric community.

Thank you.

[v-pnaroju-msft]

Hi kc1988,

We have not received a response from you regarding the query and were following up to check if you have found a resolution. If you have identified a solution, we kindly request you to share it with the community, as it may be helpful to others facing a similar issue.

If you find the response helpful, please mark it as the accepted solution, as this will help other members with similar queries.

Thank you.

[v-pnaroju-msft · Accepted solution]

Thankyou, @danextian, for your response.

Hi kc1988,

We appreciate your inquiry submitted through the Microsoft Fabric Community Forum.

From my understanding, the sorting in Matrix visuals is hierarchical by design. That is, the sorting of lower-level row fields (such as Tier, MarketCap) is performed only within the context of their parent fields (such as Year, Counterparty). This explains why you may not observe a global descending sort when selecting Tier or MarketCap.

Kindly follow the steps outlined below, which may help to resolve this issue:

1. Reorder the row fields by moving Tier or MarketCap to the top of the row hierarchy to enable global sorting. For example: MarketCap > Year > Counterparty > Tier.
2. For flat sorting across all columns, please use the Table visual instead of Matrix. Table visuals support independent column sorting without hierarchy constraints.

If you find our response helpful, we kindly request you to mark it as the accepted solution and provide kudos. This will assist other community members facing similar queries.

Should you have any further questions, please feel free to contact the Microsoft Fabric community.

Thank you.

[danextian · Accepted solution]

Hi @kc1988 

Although your matrix appears similar to a table, the sorting behavior of row categories is different. Sorting is applied relative to the hierarchy level above, meaning marketcap is sorted within the context of the Year > Counterparty > Tier hierarchy. If you want the rows to be sorted by marketcap, move it to far left or the highest level in the hierarchy.