Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
User | Count |
---|---|
89 | |
73 | |
69 | |
65 | |
56 |
User | Count |
---|---|
97 | |
92 | |
85 | |
74 | |
68 |