to convert a date to a format 'dd-mmm-yyyy' and should be able to sort the field in powerbi
Is there a way we could bring in a field to a format 'dd-mmm-yyyy' and still be able to sort. (I understand the Format function will help me with the format but it wouldnt let me sort as it would it be a text.)
Next, put your formatted date and the sort into a visual. In the Format Property under Column Headers, turn both off "Auto-size column width" and "Word Wrap". Sort your date and then "hide" your date_Sort field.