Value columns ordering in PowerBI Matrix

[Anonymous]

Hi,

In PowerBI matrix, to show metrics for different categories, you can simply put the category column in Columns section.

It's super easy but the final outputs will be hard to compare especially if there is many fields in the Values section. 

This picture shows the final output if we put the product column in the Columns section: 

To make the comparision easier, I was thinking about grouping the columns by value name and show the categories in the second row as in this image:

I need to know if it's possible to achive this in PowerBI in a straigt forward way or in a workaround.

Thanks!.

[Anonymous · Accepted solution]

you could try this setting in formatter

[Anonymous · Accepted solution]

Hi @Anonymous 

@Anonymous , thanks for your concern about this case. I tried to create a sample data myself based on the @Anonymous requirement and implemented the result. Please check if there is anything that can be improved. Here is my solution:

Sample:

Create a Matrix as follows:

Then click the button as shown in the picture.

Result:

Best Regards,
Yulia Xu

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

[Anonymous · Accepted solution]

you could try this setting in formatter

[Anonymous]

This is achievable in an Excel PivotTable, not not in the matrix visual