Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi Everyone,
I have a "Month-Year" column with values from "Apr 2017" to "Mar 2019". When I put it in Matrix visual, it displayed data from "Apr 2017" to "Mar 2019" i.e. ascending order. So, I want to display data starts from "Mar 2019" to "Apr 2017" i.e. descending order.
Also, I've tried to sort the column in descending order from visual level option and Data View but it wasn't reflected on matrix visual.
Please help.
Thanks
Solved! Go to Solution.
hi, @nyn_prshr
You could use Sort by column in Power BI Desktop
https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column
Step1:
Add a sort conditional column for "Month-Year" column.
for example:
Condition = - ( YEAR('Date'[Date])*100+MONTH('Date'[Date]) )
Step2:
Then select "Month-Year" field and then click Modeling->Sort by column->"Condition"
Result:
Best Regards,
Lin
hi, @nyn_prshr
You could use Sort by column in Power BI Desktop
https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column
Step1:
Add a sort conditional column for "Month-Year" column.
for example:
Condition = - ( YEAR('Date'[Date])*100+MONTH('Date'[Date]) )
Step2:
Then select "Month-Year" field and then click Modeling->Sort by column->"Condition"
Result:
Best Regards,
Lin
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
97 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |