Matrix order by Value over all columns

[Benedikt_Sch]

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

[Benedikt_Sch]

@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

[v-yanjiang-msft · 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.

[Benedikt_Sch]

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]

Hi @Benedikt_Sch ,

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.