Field Parameters Order in a Matrix

Hi elia22gr ,

I too have been suffering with this. My rationale for having the columns in the correct order is that I have 2 tables overlayed so that I can dynamically change the column headers. I need to be able to have columns in both tables in the order I need.

During this implementation, I found a workaround to the Columns in matrix not being sorted in the Field Parameter Sort Order. 

The workaround is to create another table with the same number of rows as your Field Parameter table and just 2 columns.

Column 1 (Sort Order) must be an integer and will be the sort column (start at 0 like in the parameter table)

Column 2 (Label) will be what you want the users to select in a slicer.

In the model, create a 1-2-1 relationship between this newly created table and the Parameter Table on the Sort Order Columns.

Change the Field Parameter Slicer in your visual to use the Label column from the newly created table and not the Field Parameter value.

Leave the table visual as it is with the Field Parameter as the Values.

Now, when you select the columns from this new slicer, they appear in the matrix / Table in the correct order.

Regards

Nigel