Forum Discussion
RichOB
Post Partisan
1 year agoNeed help updating graph sort order
Hi, I want my graph to be the UK financial year April24 - March25. I've made a column called Month_Number that says April = 1, May = 2, etc. I then changed the sort order of the Month_Name to Mo...
- Anonymous1 year ago
Hi RichOB
Please try this:
Here I create a set of sample:
Table with data from 2024,1,1 to 2025,12,1:
Then add a calculated table:
Table 2 = SUMMARIZE ( SELECTCOLUMNS ( 'Table', "Month_name", FORMAT ( 'Table'[Date], "MMM" ), "Month_number", VAR _month = MONTH ( 'Table'[Date] ) - 3 RETURN IF ( _month <= 0, _month + 12, _month ) ), [Month_name], [Month_number] )Select the [Month_name] and click sort by [Month_number]:
Connect the Table and Table 2 with the field Month_name:
The result is as follow:
.PBIX file has attached.
Best Regards
Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
RichOB
Post Partisan
1 year agoHI bhanu_gautam thanks for your reply.
Your solution makes sense and I followed the steps, but when I'm sorting the Month_Name column by Month Number, I'm getting an Error message saying A Circular Dependency Was Detected and it's not sorting the column. Any ideas how to fix this please?