Sorting in Matrix-custom column for sort

[learner03]

I have Matrix Visual and want to sort the coloumns by below critieria-

first, if Impact is Yes , then it should come at the top, then by Date 1 then Date 2and then Date 3 in Ascending order-

INPUT-

@Greg_Deckler 

[Ashish_Mathur]

Hi,

In the matrix visual, click on the Impact column, hold the Shift key and click on the Date column and so on.

[learner03]

@Ashish_Mathur Tried this, but the Blanks in date column are coming at the very top.

[Ashish_Mathur]

Hi,

Expand the filter pane and filter out the blanks from each of the Date columns.

[learner03]

@Ashish_Mathur I need the blanks as well in the date coloumn as there are more additional columns in the report that has data to be displayed.

[Ashish_Mathur]

Hi,

When you click on the heading a second time, then the sort order changes.

[miTutorials]

I'm afraid there is no easy way to do this.. The below alternative solution should help.

How to Custom Sort Multiple Columns in Power BI | MiTutorials - YouTube

[learner03]

@miTutorials thanks, but couln't get how to work with dates here