Power BI Field parameter - Order of columns in a table based on slicer display order

[Sneha_525]

Hi All,

In my report, I have created 2 field parameters defined as dimension and measures. Based on slicer selection the fields are displayed in the table.
Is there a way to define the table column order to sync with the slicer order?
Eg: Below is the current scenario, the table is displaying the columns based on the order of selection.
In the Dimensions slicer, I first selected Agent and then Location
In the Measures slicer, I selected sum, max, count, and min.

Instead, I want to display the columns based on the slicer display order
Example: Irrespective of selection order the output should display as below.
Desired output: Location, Agent, Min, Max, Sum, Count

Thanks,

Sneha

[TomWasTaken]

Interestingly the desired behaviour works in Power BI Desktop when you're developing the report, but when published (and users are using it online) it changes to adding columns onto the end as and when they're selected by the user...

So it doesn't seem like an issue with PowerBI itself unable to do it, just the behaviour of the online version.

[Kishore_KVN]

Hi @Sneha_525 ,

Bring that sorting column into the actual table where you have created calculation parameter and then in that table you have to sort with the help of this reference. You can use 'Related' by creating relationship or else you can also use 'LookUpValue' to get this table in the parameters table. 

@Sneha_525 If this post helps, then please consider accepting it as the solution to help other members find it more quickly.THANK YOU!!

[Kishore_KVN]

If I understood your question correctly, we can achieve your requirement in two ways:
1. Sort the columns in the matrix/table visual in the fields parameter

2. Create a sorting column and give order referece for those columns as per your requirement. Then sort the columns with that sorting column reference.

[Sneha_525]

Hi Kishore,
Thanks for the response!

I tried both approaches earlier and was unable to achieve my requirement.

1. Sort the columns in the matrix/table visual in the fields parameter

For the 1st option, the table is showing sort by for only the fields that are selected in the slicers (in my example: Agent, location, sum, max, count, and min)
Sort by option is sorting based on specific column values, not the column order.

2. Create a sorting column and give order references for those columns as per your requirement. Then sort the columns with that sorting column reference.

I created a table based on the sorting reference as below snapshot. I am unable to specify order based on “Sort order” column on the table visual, as Sort by column is only showing the selected slicer columns.

Thanks,

Sneha