Sort Column data in reverse order in Matrix visual

[Anonymous]

Hello,

I have the Sales Date in Column section in Matrix visual. I would like to display the recent year to the left (2019, 2018, 2018,...). The dates are in one column and drill-down to Quarter and Month. Please see the attached picture for current result.

[Anonymous]

The following solution worked for me to display the dates in descending order in a matrix:

https://stackoverflow.com/questions/59657205/how-to-sort-column-dates-in-descending-order-of-matrix-...

[v-lili6-msft]

hi, @Anonymous 

For your requirement, you could use Sort by column in Power BI Desktop to get it.

https://radacad.com/sort-by-column-in-power-bi

and for your case, "he dates are in one column and drill-down to Quarter and Month", do you mean that you only darg the date filed in "Columns" as below:

If so, you need to adjust it. you need to add Year, Quarter and Month column separately in edit queries,

and create a reverse order index for year column.

then drag them to "Columns" as below:

Now selected Year filed then sort by this reverse order index column.

here is similar post, but it doesn't need drill-down, you could refer to it:

https://community.powerbi.com/t5/Desktop/Matrix-Column-Head-Order/td-p/71572

Regards,

Lin

[Anonymous]

@v-lili6-msft Thank you for your response. Yes, I have the 'SalesDate' field only in Columns section. Could you please provide me the example of creating reverse order index column of a column?

Thanks!

[v-lili6-msft]

hi, @Anonymous 

You could try these steps:

Step1:

Add a year column in edit queries for [SalesDate],(You could add quarter, Month, and Day column in there too)

Step2:

Then create a reverse order index column for Year column, the simplest way is to create a custom as blow:

-[Year]

Step3:

Then create a matrix use these field instead of [SalesDate] as below:

Step5:

Now selected [Year] filed then click Modeling-Sort->Sort by column->choose [Index]

Result:

and here is sample pbix file, please try it.

Regards,

Lin