Forum Discussion
Need help updating graph sort order
- 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.
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.