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.
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.
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 |
---|---|
113 | |
100 | |
78 | |
76 | |
52 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |