Forum Discussion
Helper IISorting the data in the stacked column chart by Month Name
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"
)
Helper IIHi 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
Continued ContributorSelect 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
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.
- 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