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

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
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors