How to Sort Months the right way in PowerBI | Bar Chart | MI Tutorial

How to Sort Months the right way in PowerBI or Unable to Sort the Months in PowerBI? You need to watch this

[shankarmidatala]

You've made life of many PowerBi leaners very effective with this brief but effective video. Thanks for posting. Best Wishes

[akashsen]

It helped me and I learned something new today. I had been trying to do this for 2 hours. Thank you

[hawkinsmitch]

Thank you, very helpful! - and to sort across multiple years I changed it to "YYYYMM"

[mohdyousuf]

WOW I WAS facing this issues and trying to solve it from past hour thank you soo much.

[javaguitarist]

So clearly explained and a huge help. Thank you!!!

[archanasahoo]

So helpful
Thanks a lot for your nice & easy explanation

[anniya]

Thank you! seriously i was breaking my head 😅didn't know it was that simple

[saurabhMaratha]

You helped me bro and thank you the video was short 🎉to the point it was really helpful

[wfzzess]

Thanks for the short and clear explanation

[swapnavivek]

Sir.. in my case, using SWITCH(WEEKDAY()), I extracted days (Sunday, monday etc) from dates and then plotted line chart with days on x-axis. I get them on x-axis not in order. So, to make it in order like Sunday, Monday..., I used this technique explained with Day( ) instead of MONTH(). and then when I clicked on sort columns, I was not allowed to sort. it showed an error like "you cannot sort one column by another column". Can you please help me with it?

[japanese]

This is great for months, but how do you do this for days? Especially if you have days going from one month to the next, so say 29th, 30th September and then 1st, 2nd October. Power BI puts the 1st and 2nd October first...

[anatamervilelamousa]

Hi how can I story age groupings chronologically that have both days and years ? At this point they sort themselves alphabetically and the groupings are a mix of numbers and months (like 0-30 days, 1-2 years etc)

[akiozan]

If you are using the Tabular Editor, you can do the same thing easily.

[manishbaburaisingh]

great help . was in meeting it helped me on fly ..thanks

[bharatarse]

Thanks for sharing this video, one DAX formula solve sorting month in proper sequence..really it's save my time..

[dhila]

Mine has an issue --> Cannot convert value 'January' of type Text to type Date. Please help

[karnikkalani]

I don't have date column to extract month. I added month no. manually in the excel sheet which is the data source. but for some reason even after setting month no. as sort column the results don't change.

[winnieng]

thanks for explanation that! Useful :)