Forum Discussion
Column order in matrix while using field parameter
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!
5 Replies
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 👍
Hi!
I have the column order specified similarly to your suggestion. This sorting order works with slicer, but not the matrix.
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 👍
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.
Hi Lazuriii
Please see my post Re: Field Parameters Order in a Matrix - Microsoft Fabric Community for a workaround.
Regards
Nigel
