Order of columns breaks when using Field Parameters

[BerkLee]

I have a table that uses Field Parameters tied to a checkbox slicer so clients can select the columns they want to see.  But when they try to select columns out of order, the resulting table doesn't correct itself.  Is there a way to enforce the sorting properly?

I've already tried "Sorting by a Column" but all it seems to do is sort the order of the choices on the slicer and not the table itself.  Is there something I'm doing wrong?

[Duia · Accepted solution]

Hi  @BerkLee ,

I created some data:

Whether Sort ascending is selected in your Visual, it will be sorted according to the order of the slicer selection.

You can cancel it or recreate the Viusal without Sort ascending, and then sort by default.

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[SpartaBI]

@BerkLee it depends on what you choose 1st in the slicer. The order by you choose will sort them from left to right.

Showcase Report – Contoso By SpartaBI



      

[BerkLee]

Yes but is there a way to retain the default sorting order of a to l no matter what?

[JeffGray]

Hi There,

old post, but in case anyone else comes across.  I have found a solution to this problem accidentally (and the solution to your problem IS my problem.  If you add another column to the field parameter table using the same field names as the field parameter's first columns (or other names if you want, which is my case), set the sort by for this column to the sort column of the field parameter, and point the field parameter slicer, you visualization will enforce the sort order.  Or at least that's what it is doing for me even though I don't want it to!

[ToniHewlett-231]

This was super helpful - thanks!

[SpartaBI]

@BerkLee not sure.
If you won't touch the slicer then you'll have the default sorting. But once you touch it... I don't think you can with one slicer, but not 100% sure.
If you start by selecting all, and then uncheck I think it will retain the order you want. 
WDYT?