Sorting of measure to bring blank values at bottom

[Anonymous]

Hello all,

I encountered a problem in Power BI and not able to solve it. 

I have use case where I have a measure as one of the field in matrix table (called 1-YR). Whenever it’s sort on descending order the blank values are coming at the top. But, I would like to display the blank values at the bottom.

Note: I cannot replace the blank values with zero because end user want to see which funds have blank net flows for 1 yr. Please let me know if there is a workaround to solve this issue

[lbendlin]

You can sort one column by another column.  You can use this to your advantage by assigning and index to each of your non-blank values as needed. Then you use that index column to sort the other column descending. That should put the blanks at the bottom.