Name of Month in Slicer is not in right order.

[Raj2410]

Hi Image 1 is my Power query screenshot.

The Month is taken as text and if I change it to Date the complete data shows error.

So I have to keep it as text in Query.

But I want to keep my output in the Power BI model view to show Months in chronological order as - Jan, Feb , Mar...and so on.

My SLicer -Image 2 below and my Visual - image 3 below shows the data in WRONG order Please suggest a fix.

ALSO showing image -4 the ideal visual that I want.

Power Query-iMAGE 1

My Slicer- IMAGE 2

My visual- IMAGE 3

The visual that I want... ( IMAGE -4)

[Arul · Accepted solution]

@Raj2410 ,

follow the below steps,

1. Click the month name column.

2. At the top you can see sort by column option click the dropdown.

3. Now sort this column with month numbers in your table the column name is Due Month.Due Month - Copy. Now the month numbers will be sorted chronologically.

Refer these link - https://databear.com/power-bi-tips-sort-by-month-name/
https://www.sqlshack.com/how-to-sort-months-chronologically-in-power-bi/

Thanks,

Arul