Forum Discussion

Anonymous

Not applicable

7 years ago

Solved

Sclicer - Order lib month

Hello,

I m new with Power BI and i try to create a nice dashboard.

In my dashboard, i want create a sclicer with month lib from a date table.

Date lib month

01/01/2019 January

01/02/2019 February

01/03/2019 March

01/04/2019 April

01/05/2019 May

01/06/2019 June

...

01/12/2019 December

My problem the order of lib is not correct and is not comfortable to use.

I would like to have an order by month (in the year) and not an order by the fisrt letter.

With Excel the order is correct.

How can i manage the order ?

Thanks

Anonymous
7 years ago
If you have another column in your date table with the month number then you can click on sort by column in the Modeling tab and then sort it by your column monthNumber.

Anonymous
Not applicable
7 years ago
If you have another column in your date table with the month number then you can click on sort by column in the Modeling tab and then sort it by your column monthNumber.
Nathaniel_C
Community Champion
7 years ago
Anonymous ,
You may even be able to add a column if you don't have one to use Sort by Other Column.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel
- Anonymous
  Not applicable
  7 years ago
  I have a month number column in my dataset.
  I will test tomorrow and will make a feedback.
  
  Thanks