Sorting order of the columns in slicers on Slicer Reset as per field parameter sorting order

[Anonymous]

We are trying to create Dynamic Slicers based on field parameters, and trying to populate them in a slicer. Based on the slicer selection we are showing the values of the columns in a table. On "Select ALL" the order of the column remains intact in the table, but on resetting the slicer and upon selecting individual slicer values(multiple selections) the sequence of the columns in the table
is not maintained and the column selected from the slicers gets appended in the table as per the order in which they are selected in the slicers. We want the order of the columns in the table must be maintained as per the order we have in the Field parameter order. Please suggest if there any solutions to this.

[Anonymous]

Thanks, @OwenAuger , Your solution worked, thanks a lot for your swift response

[OwenAuger · Accepted solution]

Hi @Anonymous 

I can offer one suggestion (PBIX attached)

1. Create an new table containing a copy of the field parameter column (and other columns if desired). I did this with a calculated table.
2. Create a 1:1 relationship between this copy and the original field parameter table.
3. Use the column from the new table on the slicer.

Doing it this way, the order in which the filtered fields are displayed in the visual will always follow the Order column in the field parameter table, and not the order of selection.

It appears that the order of selection is followed only when the filter is applied directly on the field parameter table.

In attached PBIX, the order of the "Column Selection" fields is always Country-Region, Category, Color.

Regards

[jostnachs]

I cant download this file