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 Team,
Is there any way to sort the filter by year in Power BI desktop?
Can I sort this by year so 2018 and then 2019 Months in order?
Solved! Go to Solution.
Hello @adityavighne ,
You can, yes. You will need a column on your table that calculates a number to use for sorting the column. Something like this:
YearMonthSort = YEAR([Date])*100 + MONTH([Date])
Then you select your Year Month column in the table view and go to Modeling > Sort by Column and pick YearMonthSort
Hello @adityavighne ,
You can, yes. You will need a column on your table that calculates a number to use for sorting the column. Something like this:
YearMonthSort = YEAR([Date])*100 + MONTH([Date])
Then you select your Year Month column in the table view and go to Modeling > Sort by Column and pick YearMonthSort
Thank You!
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 |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |