Forum Discussion
Sort Slicer Values
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
Hi Lin,
Thanks for the reponse. I've done all the steps but when I click on "Sort by Column" there's no drop down option? Any idea what could be the cause of that?
Hi jeve . For me, the "Sort by Column" drop-down only becomes enabled when I select both the slicer and the associated table in the Fields pane. Also, the "Sort by Column" drop-down does not show all fields within the table. It shows columns but no measures. I hope this is helpful.
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