Forum Discussion
Month Sorting
I have create one report( Purchase Monthwise.. But the months are not sorting... and it lokks like as per the image. Can any one help me to overcome this:)..
MartynRamsden
Solution Sage
Solution SageHi GemcoDesigns
Your visualisation looks like it's sorted by Purchase Amount descending.
Click the ellipsis (...) in the top right hand corner of the chart and select Sort by>>Month.
When you do this, you may find that your months are sorted alphabetically rather than chronologically.
If so, you need to add a 'Month Sort' column to your model as detailed here: docs.microsoft.com/en-gb/archive/blogs/samlester/sorting-by-month-names-in-power-bi
Best regards,
Martyn
If I answered your question, please help others by accepting it as a solution.