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

Поделиться
HTML-код
  • Опубликовано: 28 дек 2024

Комментарии • 89

  • @shankarmidatala2049
    @shankarmidatala2049 4 месяца назад +4

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

  • @akashsen5881
    @akashsen5881 Год назад +3

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

  • @hawkinsmitch
    @hawkinsmitch Год назад +2

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

  • @mohdyousuf8687
    @mohdyousuf8687 Год назад

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

  • @lachlanbrown2366
    @lachlanbrown2366 Год назад

    Best power bi teacher ever!

  • @archanasahoo9670
    @archanasahoo9670 10 месяцев назад

    So helpful
    Thanks a lot for your nice & easy explanation

  • @martinnaydenov8643
    @martinnaydenov8643 11 месяцев назад

    thanks bro, quick and informative!

  • @japanese2811
    @japanese2811 Год назад

    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...

  • @anatamervilelamousa2520
    @anatamervilelamousa2520 8 месяцев назад

    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)

  • @abiel237
    @abiel237 3 месяца назад

    Never Knew it was so easy :), Thanks

  • @anniya12345
    @anniya12345 Год назад

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

  • @swapnavivek9647
    @swapnavivek9647 8 месяцев назад

    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?

  • @karnikkalani1516
    @karnikkalani1516 Год назад

    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.

  • @purepenworld2081
    @purepenworld2081 Год назад

    Thank you for this. I saves me today

  • @javaguitarist
    @javaguitarist Год назад

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

  • @gontsemotubatse9886
    @gontsemotubatse9886 4 месяца назад

    This was very helpful. Thank you.

  • @saurabhMaratha
    @saurabhMaratha Год назад

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

  • @princepeniel8796
    @princepeniel8796 29 дней назад

    Excelllent!

  • @claymcclendon
    @claymcclendon Год назад

    I am not able to make a new column. Maybe I can use New Measure?

    • @MITutorials
      @MITutorials  Год назад

      Nope. You will have to add a new column.

  • @PremsaiKanigalpula
    @PremsaiKanigalpula Год назад

    Thanks for the short and clear explanation

  • @manishbaburaisingh1985
    @manishbaburaisingh1985 2 года назад

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

  • @xandrew_._
    @xandrew_._ 2 года назад

    Sir where can i get the full video of doing measures nd all

  • @AndiLesmana-e1s
    @AndiLesmana-e1s Месяц назад

    Thank you, very helpful

  • @xiuhou4858
    @xiuhou4858 Год назад

    What if the axis sits in Yearmonth(like202301) , can I still use this method please?

  • @kiranraj5326
    @kiranraj5326 4 месяца назад

    Thank you this helped me!

  • @RUPALIRAKIBE-v1m
    @RUPALIRAKIBE-v1m Месяц назад

    I performed this same process but it give error in sorting

  • @dhila6846
    @dhila6846 6 месяцев назад

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

  • @anisayuni427
    @anisayuni427 Год назад

    YOU ARE AWESOME! THANK YOU!

  • @rachananarla9868
    @rachananarla9868 7 месяцев назад

    But my month column is in text format and it doesn't work for me

  • @Alex-bk3xm
    @Alex-bk3xm 2 года назад +1

    Thanks, it helped me a lot!

  • @deCarvalhoLucas
    @deCarvalhoLucas Год назад

    You are a life-saver!

  • @xolapower
    @xolapower 11 месяцев назад

    Thanks. Nicely done.

  • @TERAnalytics
    @TERAnalytics Год назад

    Very helpful. Thank you

  • @numanjaved2657
    @numanjaved2657 3 года назад

    Bht aala Sir you are a gem

  • @jitenderjuneja6529
    @jitenderjuneja6529 6 месяцев назад

    Thank you so much sir really helpful

  • @RakibRaihan-y9h
    @RakibRaihan-y9h Год назад

    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.

  • @powerbis.1794
    @powerbis.1794 Год назад

    YOU ARE SANSRPIT GENIUS!

  • @omkarbodake6763
    @omkarbodake6763 Год назад

    Thanks a lot!!👍

  • @akiozan
    @akiozan Год назад

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

  • @shubhabratadey
    @shubhabratadey Год назад

    Great Help. Many thanks

  • @hamidraza2988
    @hamidraza2988 Год назад

    Thanks man 👍

  • @winnieng3607
    @winnieng3607 Год назад

    thanks for explanation that! Useful :)

  • @craignyatondo5521
    @craignyatondo5521 Год назад

    Simple and to the point!

  • @sakthisowmyat4491
    @sakthisowmyat4491 Год назад

    Life saver💯

  • @ryanchannel_HK
    @ryanchannel_HK Год назад

    This is amazing

  • @harshavardhan4800
    @harshavardhan4800 3 года назад

    Thanks for this 😊 . Do more

  • @lukakhitaridze-m5x
    @lukakhitaridze-m5x 11 месяцев назад

    Really helpful Video

  • @unnikrishnansanthosh
    @unnikrishnansanthosh 10 месяцев назад

    simple and super useful

  • @DeepSarkar-ud7hx
    @DeepSarkar-ud7hx 7 месяцев назад

    This is not working on my pc. Can anyone help ? There is no month number is showing. I have tried so many times.

  • @navjotsayal
    @navjotsayal 10 месяцев назад

    my table doesnt have date

  • @jagank7812
    @jagank7812 2 года назад

    Thanks a lot, has been very useful

  • @umairraheem6894
    @umairraheem6894 Год назад

    If data have no date then how we sort data as our requirement

    • @MITutorials
      @MITutorials  Год назад

      You will have to create a Date column based on whatever related field you have.

  • @hemanthreddy7608
    @hemanthreddy7608 Год назад

    How to sort If it's date instead of month how to sort largest date to smallest

    • @MITutorials
      @MITutorials  Год назад

      You can simply click on the column header and sort it.

  • @mayurifunde5398
    @mayurifunde5398 5 месяцев назад

    Thank you so much..!!

  • @sowjanyakake5720
    @sowjanyakake5720 Год назад

    Thanks a ton, very useful

  • @DeepakChoudhary-w7t
    @DeepakChoudhary-w7t Год назад

    Not worked for me, still showing same.

  • @Nomedlife
    @Nomedlife Год назад

    very nice video
    but if you have year change by month

  • @hamzali84
    @hamzali84 Год назад

    God Bless you. i mean it..

  • @dhanushkumarsg1188
    @dhanushkumarsg1188 Год назад

    Thank you bro .....

  • @carlocalingasan998
    @carlocalingasan998 5 месяцев назад

    Thank you.

  • @elfridtech
    @elfridtech Месяц назад

    Thank You Very Muchh

  • @bharatarse1503
    @bharatarse1503 3 года назад +1

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

    • @bornout1990
      @bornout1990 2 года назад

      How to write DAX fungsion?

  • @KhunAyeMinThet
    @KhunAyeMinThet Год назад +1

    the video is not clear

  • @ramandeepsr
    @ramandeepsr 7 месяцев назад

    Thanks!

  • @VTC05
    @VTC05 2 года назад

    Thank you!!

  • @rgrgrwrt
    @rgrgrwrt Год назад

    very helpful

  • @-chGayathriCSM-vn3yz
    @-chGayathriCSM-vn3yz 4 месяца назад

    thanks bhaiiii

  • @iccstudio1106
    @iccstudio1106 Год назад

    Bhai Apr to Mar financial year ka nikalo pls

  • @marnitztaylor9509
    @marnitztaylor9509 2 года назад

    Thank you

  • @armaanpasha8953
    @armaanpasha8953 2 года назад

    Thanks

  • @hashangeorge9476
    @hashangeorge9476 3 месяца назад

  • @BrianClark-k8h
    @BrianClark-k8h 5 месяцев назад

    How can it be so much dumber than say, Microsoft Excel?

  • @aneeqahorrie8198
    @aneeqahorrie8198 10 месяцев назад

    Thank you!!

  • @muhammadalpimalfarolis6730
    @muhammadalpimalfarolis6730 6 месяцев назад

    THANKS !!

  • @habibshelle5084
    @habibshelle5084 Год назад

    Thanks

  • @dilipinamdar5523
    @dilipinamdar5523 2 года назад

    thank you

  • @Albert-SC08
    @Albert-SC08 2 месяца назад

    Thanks!

  • @sreeamt2044
    @sreeamt2044 Год назад

    Thanks