Column order in matrix while using field parameter

[Lazuriii]

Hi!

I have created a field parameter table for my measures. The measures show sales, margins and costs. The idea is that the end-user could choose, which measures they view in the matrix. Now, I want the measure columns to always appear in the same order in the matrix. However, Power BI's logic is that each selected column appears to the right side of the last selected column. 

Here's a very simplified version of my parameters table:

Measure	Order
Sales	1
SGA	2
EBITA	3

What I want is that if the user first chooses SGA (2) and then Sales (1), the Sales (1) column would appear before the SGA (2) column to the matrix.

Thanks in advance!

[Nigel]

Hi @Lazuriii 

Please see my post Re: Field Parameters Order in a Matrix - Microsoft Fabric Community for a workaround.

Regards

Nigel

[Idrissshatila]

Hello @Lazuriii ,

Try sorting it in the matrix by the parameter field.

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin

[Lazuriii]

Hi @Idrissshatila ,

It seems that there is no option to sort the matrix by the parameter field. The only sorting I can find is to sort the values, but that is not what I need.

[Idrissshatila]

Hello @Lazuriii ,

You could specify the column orders in the field parameter dax, like the following screenshot

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin

[Lazuriii]

Hi!

I have the column order specified similarly to your suggestion. This sorting order works with slicer, but not the matrix.