Sorting the data in the stacked column chart by Month Name

[grkanth81]

Hi All,

I am facing an issue with sorting the data in the Stacked column chart.

Please check the below screenshot. 

I would like the values inside the stacked bar chart to be sorted like July, August, September, October, November etc.... Any idea how to achieve this?

Thanks,

Rav

[Hardik]

hey ! kindly check the data type of your Months column ,if it is a string or date type .Maybe the data is not geting displayed in a chronological order.

[grkanth81]

Hi Hardik,

The MonthName column is having a data type of Text.

Basically i have one column which has date values and as i created this new column MonthName from it using DAX

=FORMAT([InvoiceDate],"MMMM")

Thanks

[Hardik · Accepted solution]

Select the months column and in the modelling tab ,select sort by column.I hope this works for you.

Or you can also assign numbers to the months ,if the above doesn't work.

Month=SWITCH([MonthNumber],
1,"January",
2,"Feburary",
3,"March",
4,"April",
5,"May",
6,"June",
7,"July",
8,"August",
9,"September",
10,"October",
11,"November",
12,"December",
"Invalid Month Number"
) 

[grkanth81]

Thanks Hardik.

Your first option worked now (going to data modelling and selecting the sort by column option). I was doing it wrong initially.

Its all fixed now.

Thanks

[Hardik]

@grkanth81 pleasure 

[grkanth81]

Hi Hardik,

I already have another column which displays only Month Numbers. when i try use with this, it works perfectly fine, but i would like to display names of the months in the chart rather than numbers.

Thanks...

[Hardik]

You can format the month number column to the month name as you did for the invoice date column.

[Hardik]

Select the months column and in the modelling tab ,select sort by column.I hope this works for you.

Or you can also assign numbers to the months ,if the above doesn't work.

Month=SWITCH([MonthNumber],
1,"January",
2,"Feburary",
3,"March",
4,"April",
5,"May",
6,"June",
7,"July",
8,"August",
9,"September",
10,"October",
11,"November",
12,"December",
"Invalid Month Number"
)