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:)..
Hi 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.