Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi Experts
I am trying to sort my visual into the correct month order (ascending by month). I have data from Sept 2023 onwards. The 2023 months are in the correct order however not for 2024. See below
I'm probably missing something very simple, any advice greatly received.
thanks in advance
Solved! Go to Solution.
Watch this short tutorial to sort months on the Column chart.
How to Sort Months the right way in PowerBI | Bar Chart | MI Tutorial - YouTube
Watch this short tutorial to sort months on the Column chart.
How to Sort Months the right way in PowerBI | Bar Chart | MI Tutorial - YouTube
Hi @Elisa112
I suspect your 'date/month' column is actually text and in your chart it is sorting alphabetically in descending order S -> A
You need to use a proper date column like this
The data will then sort correctly
Phil
Proud to be a Super User!
thanks for your assistance, my tables looks like this:
I also have a customer table with dates such as (referral date, start date). So I created a measure to calculate the total customers but the visual shows the months in the wrongorder. I have tried creating a sorting column on my customer table but I get the following error when I try this solution
Any further help much appreciated.
Elisa112
@Elisa112 You can sort the months by using the following calculated column:
Sorting Condition = - ( YEAR('Table'[Date])*100+MONTH('Table'[Date]) )
Sort the month by sorting condition:
Power BI file attached:
Regards,
Fahad Qadir
Did I answer your question? Mark my post as a solution!
Hello,
what columnd did you put on the x axis? Like month? You have to sort that column by date.
If it's a column from the calendar table.
You go in the dataview, then select the month column, than select order by date, if you can't order by date you need a month number column and then you sort by month number. Hope I made my point
User | Count |
---|---|
94 | |
86 | |
78 | |
70 | |
63 |
User | Count |
---|---|
114 | |
99 | |
97 | |
65 | |
59 |