Forum Discussion
Solved
Sort Slicer Values
I have a list of data with 3 possible values - B-CS, C-CS and LT. When applying the slicer it defaults to sorting alphabetically; is it possible to sort by - LT, B-CS and then C-CS?
hi, jeve
If the rank is a column not a measure? Measure won't show in it.
If you still have the problem, please share a simple pbix file for us have a test.
By the way, the column should be created in edit queries, not a calculate column.
and here is my sample pbix file, please try it.
Best Regards,
Lin
HI, jeve
Try this simple way:
Step1:
Create a rank column for this column in Edit Queries
Step2:
Then select [Task Type] filed, click Modeling->Sort by column->selected [Rank]
Result:
https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column
https://radacad.com/sort-by-column-in-power-bi
Best Regards,
Lin
Thank you. It helps a lot.