Sort Measure with Blanks always at bottom

[meirlicht]

I have a table visual with multiple columns including various measures. When I try to sort ASC by a measure column, the blanks in that column are all brought to the top because they are treated like zeros. I want the blanks to always be at the bottom and not be included in the sorting. (I tried adding an empty space to the blank values making them a string, but then the blanks appear at the top when I sort the column DESC.) Is there any work around to do this? Thank you!

[v-easonf-msft · Accepted solution]

Hi， @meirlicht 

Inevitably you will need to add custom index columns for sorting.

You need to add that index column to the chart, then hide the sort column by shortening the column width after sorting.(turn off word wrap in the table/matrix setting and drag the field)

Best Regards,
Community Support Team _ Eason