display month correctly

[asmagh]

Hello, please when I add the months in a graph they do not appear in the order of January until December I know not how to display them growing from January to December knowing that I The poster by libelle

[vanessafvg]

@asmagh do you have a month number?

if so under the modelling tab set the month name to sort by the month number

[asmagh]

i try it but still doesn't work 😕 

[vanessafvg]

@asmagh are you sorting by the number?  not the text?

ie 

 month name     month no

jan                        1

you must sort by no not name

[asmagh]

i'm sorting the name by the id (No) and still don't work

[Iadem · Accepted solution]

Create new Table in PBI

1) Calendar = Calendar("01-01-2017";"31-12-2017")

Create Columns

2) Month_Nu = Month([calendar])

3) Month = Format([calendar];"MMMM")

And Sort Month by Month_Nu

And create relationship (Calendar - Your date)

Oh, try TRY turn off visualisation sort. Sometimes "visualisation sort" can errors

[asmagh]

thks a lot it works