Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more
So everything we do in higher education is by academic year, which starts July 1 and ends June 30. So when I want to display data in a bar graph by the academic year from beginning to end, how would I accomplish this instead of getting alphabetical?
I need it displayed in the following order:
With July being the first in the table and June being the last.
Solved! Go to Solution.
Hi @JMWDBA
I suggest you to create an additional column in your date table.
Defining that July is 1, August is 2 an so.
Then define the sort order by this extra column and hide the extra column.
Please contact me, if you need some help.
sorry, i want to add order in my date table, could you help me what is the best way to add the order according to month?
In this link you will find another choices
http://community.powerbi.com/t5/Power-BI-User-Group-Norway/Months-sorting/gpm-p/121383#M1149
Hi @JMWDBA
I suggest you to create an additional column in your date table.
Defining that July is 1, August is 2 an so.
Then define the sort order by this extra column and hide the extra column.
Please contact me, if you need some help.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.