Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
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 ,
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
Proud to be a Super User!
I have a month number column in my dataset.
I will test tomorrow and will make a feedback.
Thanks
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
99 | |
76 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |