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...
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)
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?
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.
You've made life of many PowerBi leaners very effective with this brief but effective video. Thanks for posting. Best Wishes
It helped me and I learned something new today. I had been trying to do this for 2 hours. Thank you
Thank you, very helpful! - and to sort across multiple years I changed it to "YYYYMM"
WOW I WAS facing this issues and trying to solve it from past hour thank you soo much.
Best power bi teacher ever!
Thank you ! Means a lot! 😊
So helpful
Thanks a lot for your nice & easy explanation
thanks bro, quick and informative!
Glad it helped!
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...
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)
Never Knew it was so easy :), Thanks
Thank you! seriously i was breaking my head 😅didn't know it was that simple
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?
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.
Thank you for this. I saves me today
So clearly explained and a huge help. Thank you!!!
This was very helpful. Thank you.
You helped me bro and thank you the video was short 🎉to the point it was really helpful
Excelllent!
I am not able to make a new column. Maybe I can use New Measure?
Nope. You will have to add a new column.
Thanks for the short and clear explanation
great help . was in meeting it helped me on fly ..thanks
Sir where can i get the full video of doing measures nd all
Thank you, very helpful
What if the axis sits in Yearmonth(like202301) , can I still use this method please?
Yes!
Thank you this helped me!
I performed this same process but it give error in sorting
Mine has an issue --> Cannot convert value 'January' of type Text to type Date. Please help
YOU ARE AWESOME! THANK YOU!
But my month column is in text format and it doesn't work for me
Thanks, it helped me a lot!
You are a life-saver!
Thanks. Nicely done.
Very helpful. Thank you
Bht aala Sir you are a gem
Thank you so much sir really helpful
Hi, can any one assist me to sort out month. although i am following this video to sort out, i can't after trying several time.
YOU ARE SANSRPIT GENIUS!
Thanks a lot!!👍
If you are using the Tabular Editor, you can do the same thing easily.
Great Help. Many thanks
Thanks man 👍
thanks for explanation that! Useful :)
Simple and to the point!
Life saver💯
This is amazing
Thanks for this 😊 . Do more
Really helpful Video
simple and super useful
This is not working on my pc. Can anyone help ? There is no month number is showing. I have tried so many times.
my table doesnt have date
Thanks a lot, has been very useful
If data have no date then how we sort data as our requirement
You will have to create a Date column based on whatever related field you have.
How to sort If it's date instead of month how to sort largest date to smallest
You can simply click on the column header and sort it.
Thank you so much..!!
Thanks a ton, very useful
Glad it was helpful!
Not worked for me, still showing same.
very nice video
but if you have year change by month
God Bless you. i mean it..
Thank you bro .....
Thank you.
Thank You Very Muchh
Thanks for sharing this video, one DAX formula solve sorting month in proper sequence..really it's save my time..
How to write DAX fungsion?
the video is not clear
Thanks!
Thank you!!
very helpful
Glad it helped
thanks bhaiiii
Bhai Apr to Mar financial year ka nikalo pls
Thank you
Thanks
❤
How can it be so much dumber than say, Microsoft Excel?
Thank you!!
THANKS !!
Thanks
thank you
Thanks!
Thanks