Sort table visual based on a column that has dates where some days are null

[Anonymous]

I have a table visual that I would like sorted from oldest to newest but some of the rows contain null. How do I sort to force the nulls to be last and the oldest date (where there is a date) to be first?

Here it sorts oldest to newest...but I want to go newest to oldest

If I do the sort from newest to oldest,  I get blank rows. I want the blank rows to display but I want them at the end

[v-diye-msft]

Hi @Anonymous 

If you've fixed the issue on your own please kindly share your solution. if the above posts help, please kindly mark it as a solution to help others find it more quickly.thanks!

[Greg_Deckler]

Well perhaps create a new column and if the column is null, make it 1/1/9999 as a date, otherwise just the date from the column. Sort on this new column.

[Tad17]

Hey @Anonymous 

check out the two threads below and see if they help:

https://community.powerbi.com/t5/Desktop/handling-blanks-in-tables-and-matrix/td-p/337041

https://community.powerbi.com/t5/Desktop/sort-by-ascending-values-with-non-blanks-on-top/td-p/689199

If these help please kudo.

Ifthey solve your problem consider accepting this post as possible solution.