Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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!
Hi @Lazuriii
Please see my post Re: Field Parameters Order in a Matrix - Microsoft Fabric Community for a workaround.
Regards
Nigel
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 👍
Proud to be a Super User! | |
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.
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 👍
Proud to be a Super User! | |
Hi!
I have the column order specified similarly to your suggestion. This sorting order works with slicer, but not the matrix.
User | Count |
---|---|
73 | |
70 | |
38 | |
24 | |
23 |
User | Count |
---|---|
96 | |
93 | |
50 | |
41 | |
40 |