Forum Discussion

RichOB's avatar
RichOB
Icon for Post Partisan rankPost Partisan
1 year ago
Solved

Need 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...
  • Anonymous's avatar
    Anonymous
    1 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.