Forum Discussion
Sort Column data in reverse order in Matrix visual
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
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!
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