Forum Discussion
Order of columns breaks when using Field Parameters
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?
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
7 Replies
Yes but is there a way to retain the default sorting order of a to l no matter what?
JeffGrayAdvocate I
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!
DuiaResolver II
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
