Sort Slice Order - Sort Columns does not have Unique Values

[mwnance]

I have a table that has multiple rows  For example

Location Id,  Iteration Name, Start Date

I can have Several Iteration names taht have the same start Date,    I would like to sort the iterations on start date but when I try to sort by colum it does not let me sort them becasue start date is unique.  I also have a filter that changes the availalbe iteration names by location ID.

So is there a way to sort these?

[Anonymous · Accepted solution]

Hi @mwnance,

You can extract the current field value to a new table and distinct them into unique values, then you can add an index column to that table and set 'sort by column' propety based on the index field.
After these steps, you can link to the raw table fields and use them on the slicer, these custom sort orders will be applied on the slicer.

Custom Sorting in Power BI  

Regards,

Moonlight

[ronaldbalza2023]

Hi @mwnance , create a day number on your table using Power Query and from there, you can sort it by start date.