Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare 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
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
113 | |
108 | |
107 | |
92 | |
67 |
User | Count |
---|---|
162 | |
133 | |
132 | |
93 | |
91 |