Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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.
The following solution worked for me to display the dates in descending order in a matrix:
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
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
65 | |
63 | |
52 | |
37 | |
36 |
User | Count |
---|---|
82 | |
66 | |
61 | |
46 | |
45 |