Sorting Dates

[Anonymous]

Hi

I have a table that looks at when a review is due and when it is actually completed. Each person has multiple actual review dates and I want to sort them so they line up next to the due date. What I want to do is organise the earliest review date as review 1 then the next date as review 2 and so on. The bloew table is what I have so far, it is so I can compare if the actual review date was done before the due date. Hope that makes sense. Any help is greatly appreciated, thanks

[v-lili6-msft]

hi, @Anonymous 

I think you need to use the Sort by Column in power bi.

https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column#sort-using-the-sort-by-column-button

https://radacad.com/sort-by-column-in-power-bi

If not your case, please share your expected output in an excel, I'm sorry that I don't understand which in your screenshot.

Best Regards,

Lin

[Anonymous]

Hi @v-lili6-msft 

Thanks for the response.

Currently this is the output I get on BI

I want to organise the actual date in the end column so I get the below result so the actual first review can be put next to the 1st review due by. It would also be useful if the date would be green or red depending on if it is before or after the review due by date. Soemtimes 4 reviews may not have been completed so would that cause an issue. Hope that makes sense, thanks

[v-lili6-msft]

hi, @Anonymous 

Ok I know, Not sure if it could be achieved for your requirement,

Could you share a simple sample pbix file for us have a test? Just from the screenshot we couldn't see your data mode.

Best Regards,

Lin