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,
I'm looking to compare values across months year by year. This I have working basically, but our financial year runs Oct-Sep, so wondered how I could change this chart to start with Oct and run to Sep?
Thank you!
Solved! Go to Solution.
@MartinConroy , You need to create a month sort column, assume you have this column in date table
month sort = if(month([date]) <10 , 3+ month([date]) , month([Date]) -9)
mark this as the sort column of the month
How to Create Sort Column and Solve Related Errors:
https://www.youtube.com/watch?v=KK1zu4MBb-c
Thank you - this example was most helpful. I was struggling because I was basing the month on the month part of a date hierarchy field. Once I explicitly stored the month number all was fine 🙂
@MartinConroy , You need to create a month sort column, assume you have this column in date table
month sort = if(month([date]) <10 , 3+ month([date]) , month([Date]) -9)
mark this as the sort column of the month
How to Create Sort Column and Solve Related Errors:
https://www.youtube.com/watch?v=KK1zu4MBb-c
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
101 | |
86 | |
64 |