Sorting year and month on a graph

[PowerBINoob12]

Hi,

I'm having immense trouble getting a graph to show the last 6 calendar months in order of the correct month.

Here is what i have on my Calendar table:

[Sort] is a combination of the year and month Jan2022 being 202201, feb 2022 being 202202 etc. I am then sorting it by this value ([sort]) on the table.

Then when I add [sort order] to a graph it has december in the incorrect position on both graphs:

Am I correct to think that if the table is sorted by [sort] the then [sort order] should sort in this order on the graphs?

Can anyone help me please?

additional pic that shows the value in dec2022 is less than Jan2023: 

[Syndicate_Admin]

Hello.

In the CALENDAR table you select the MONTH column LETTER

Then, at the top, you choose SORT BY COLUMN and there you choose the column MONTH NRO

And you're done

You tell me xfa

[PowerBINoob12 · Accepted solution]

I figured it out in the end.

I needed to select the column I wanted to sort before I click "sort by column". I had just assumed clicing sort by column would do the whole table 🙂

[AmiraBedh]

What is the type of the Sort combination column ?

[PowerBINoob12]

Hi Thanks for your reply and help.

It was set to text but i've just changed it to whole number - but still the same issue on the graphs.