Forum Discussion
Elisa112
Helper V
Helper VSort dates in month order for bar chart visual
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 b...
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
fahadqadir3
Solution Supplier
Solution SupplierElisa112 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!