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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Benedikt_Sch
Helper I
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

 

AreaGroupQty
1A25
1B5
2A2
2C20

 

Expected Matrix sorting when Group is expanded

 

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

 

AreaGroupQty
1A25
2C20
1B5
2A2

 

Update with better example:

 

Benedikt_Sch_0-1667983187467.png

 

Best wishes

Benedikt

 

1 ACCEPTED SOLUTION

Hi @Benedikt_Sch ,

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.

View solution in original post

4 REPLIES 4
Benedikt_Sch
Helper I
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.

 

 

Benedikt_Sch_0-1667982873462.png

 

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

 

Benedikt

 

Hi @Benedikt_Sch ,

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.

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

Maybe I can find another way to solve the problem.

 

Best Regards

Benedikt

 

v-yanjiang-msft
Community Support
Community Support

Hi @Benedikt_Sch ,

Maybe I'm not very clear about the problem.

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

vkalyjmsft_0-1667978314830.png

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

vkalyjmsft_1-1667978364867.png

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
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

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

Jan NL Carousel

Fabric Community Update - January 2025

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