Skip to main content
cancel
Showing results for
Search instead for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper I

## Matrix order by Value over all columns

Hey,

I want to sort two colums (area and group) by qty sold in a Matrix.

By default a matrix always sort a value by the first column (area). My users expect when drill down to area and group viewport to see a sorting order considering both columns.

Is it possible to create a descanding sorting order in a matrix like in a table?

Example:

Matrix  default sorting when order by QTY

 Area Group Qty 1 A 25 1 B 5 2 A 2 2 C 20

Expected Matrix sorting when Group is expanded

-> Behavior like in a table but with option to drill up and down

 Area Group Qty 1 A 25 2 C 20 1 B 5 2 A 2

Update with better example:

Best wishes

Benedikt

1 ACCEPTED SOLUTION
Community Support

Understand. Unfortunately I'm afraid it can't be achieved in a matrix. In a matrix, it has hierachy, Groups which has same Area can only placed besides, this will not be disrupted.

Best Regards,
Community Support Team _ kalyj

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

4 REPLIES 4
Helper I

@v-yanjiang-msft @achanikya  thank you for your replies.

I will try to make the problem more clear.

I have two columns and one measure.  My goal is to sort both columns by that measure in a matrix.

If I use a table visual all is fine and Power BI consider both columns.

But if i use a matrix-visual (my users need to expand / colapse)   Power BI only sort by Sum of Area. So Area 2 Group B (20 sales) ist ranked lower than Area A with Group B (5 sales). I do understand why Power BI sorting it this way. For most cases this ist the best behaviour. But not for my case right now. I wand a List ordered by QTY sold. No Matter whicht Area or Group if both is expanded.

If there is not option to get this in a matrix. I will try to work with tables and bookmarks

Benedikt

Community Support

Understand. Unfortunately I'm afraid it can't be achieved in a matrix. In a matrix, it has hierachy, Groups which has same Area can only placed besides, this will not be disrupted.

Best Regards,
Community Support Team _ kalyj

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

Helper I

Thanks for the answer. I had already expected something like this.

Maybe I can find another way to solve the problem.

Best Regards

Benedikt

Community Support

Maybe I'm not very clear about the problem.

If sort by Area column, it will display like this:

If sort by Qty column, it will display like this:

If this is not the case, could you please explain more about the result.

Best Regards,
Community Support Team _ kalyj

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

## Helpful resources

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Join our Community Sticker Challenge

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

#### Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

#### Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors