Forum Discussion
sort by custom Index order
Still looking for assistance in establising a correct sort order for Slicer:
I create a custom column to set the new Index order, however, when I try to implement it as a slicer it reverts back the alpha sort instead on the established sort order.
the table view looks correct,however, when I change to slicer it reverts back.
NOTE: THE 3000+ is out of order, it should follow the 501-3000 selection option.
Please see my previous post:
kfschaefer I can see the SortID was created in the Query Editor - that will not affect this!
What I suggested is to concatenate the 2 Columns in the Data View and then use that new concatenated column for your slicer
the concatenated column is a new column with a new name - thats why it has ! at the end
in the Data View => Modeling Tab => click New Column => type Live Range! = .....
7 Replies
kfschaefer I beleive the issue you are having is to do with telling PBI how to sort. In PBI desktop click on the data button (looks like a table):
Then click the modelling tab in the ribbon. In the picture above you can see a button called Sort By Column. If you select table 'LiveRangeList' and then select column [Live Range] the Sort by column button will then allow you to sort the Live Range column by the SortID. This will maintain the desired sorting you require.
If this doesnt make sense please let me know.
Thanks,
Giles
I already did that - the issue is when I change the table visualization to a slicer the sort order does not hold.
K
If you don't mind the numbers in the slicer try concatenating the 2 columns. This will guarantee they'll be sorted the way you want!
