Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
72 | |
71 | |
57 | |
38 | |
36 |
User | Count |
---|---|
83 | |
67 | |
62 | |
46 | |
45 |