Slicer in horizontal orientation does not show Month in chronologic order - How to Solve?

[Anonymous]

Hi there,

I have a slicer for filter Months in horizontal orientation but it does not let me have it in chronologic order. My table already has ID for each mont (from 1 to 12) and it's already sort by this column but nothing happens

Any ideas?

[parry2k · Accepted solution]

@Anonymous but you also have to sort month column by month number column,Sort one column by another column in Power BI Desktop - Power BI | Microsoft Docs

✨ Follow us on LinkedIn

Check my latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

[Greg_Deckler]

@Anonymous You need a numeric "Sort By" column for months. So in your Power Query put a numeric month number and then use that as your "Sort By" column for you month names column.

[Anonymous]

@Greg_Deckler That's what I've done. Open the table with the query editor, sort the column Month Number ascending and then Close&Apply. Am I missing something?

[Greg_Deckler]

@Anonymous You want this: