Customize the Legend Order in Power BI - Stacked Column Chart

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

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

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

    After spending a few hours researching this technique is by far the easiest method when you have text fields for a Legend. Thank you!

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

    Thank you, you released me from huge struggle!

  • @snowdrum47
    @snowdrum47 2 года назад +1

    Thank you omg. Been looking everywhere for this solution. You sir, deserve a medal.

  • @vzmol
    @vzmol 2 года назад +1

    I finally get it, thank you. I also learned something more - upvote well earned. Have a great day!

  • @michaelreed5118
    @michaelreed5118 3 года назад +3

    This video was exactly what I needed and everything was explained very well! Thank you for the content

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

    This is so needlessly complicated but thanks for your help!

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

    that's so awesome - thanks for this tutorial for custom legend sorting

  • @auntykatie5167
    @auntykatie5167 5 месяцев назад +1

    This video is excellent - thank you!

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

    Really helpful with easy explanation. Understood somethin new today. Thank You.

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

    Great video, this works well and is a pretty robust solution. It would be interesting to know how to create the reference columns using Power Query Editor and M. Thank you!

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

    Very helpful and it worked smoothly.. thanks a lot for this wonderful session

  • @SD-rj7og
    @SD-rj7og 2 года назад +1

    Many thanks, really useful

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

    This was a perfect video, thank you very much for making it so concise!

  • @就已
    @就已 3 года назад +1

    amazing! thx for sharing!
    but i want to ask a question, using related() bringing sort column to fact table will
    increase model size, is there have other workaround? thx!

  • @Mack-the-Knight
    @Mack-the-Knight 3 года назад +1

    Does this work for controlling sort order in a Stacked Area chart?

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

    Great explanation. I wonder if we can create the table within the calculated column code and spare the unused table.

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

    You have fulfilled the prophecy!

  • @yogishag3393
    @yogishag3393 3 года назад +4

    Any thoughts on sorting legends based on Sales Value instead of the custom sort?

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

      try with Ascending/descending sorting already given when you click on 3dots on right top of the chart

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

    Exactly what I needed! Thank you.

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

    Very well explained! Thanks a lot man!

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

      Perhaps you can help with my situation. If you wanted to use the sort table you created, to sort multiple columns from your main 'Sales Date' table, how would you do this?
      In my case, I have survey data, One main table with responses where each column (9 columns total) is a particular question. Each question has the same set of answers (Strongly Disagree, Disagree, Neutral, Agree, Strongly Agree). I tried creating the relationship between the two tables using a many to many connection, but it wouldn't work.
      In the end I just replicated your method 9 times, since I'm pressed for time, but that is not scalable.
      Any help you can provide would be much appreciated. Thanks!

  • @kevalpatel2882
    @kevalpatel2882 2 года назад +1

    Thanks man, appreciate it :)

  • @AvishekRoy-yv2kg
    @AvishekRoy-yv2kg 6 месяцев назад

    Thank you, helped a lot.

  • @aidarfaizrakhmanov1901
    @aidarfaizrakhmanov1901 2 года назад +1

    I wasted almost an hour trying the solutions on the internet until I stumbled upon yours. Like & subscribe from me mate

  • @bhaveshrawat1364
    @bhaveshrawat1364 2 года назад +1

    Thanks bro, was helpful!!

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

    is the both directional relation necessary?

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

    thanks. simply helpful!

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

    Thank you so much. This is incredibly helpful even to this day!

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

    Saved my life! Thank you my friend!

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

    Excellent video! Thanks

  • @TheMrWARLORD
    @TheMrWARLORD 2 года назад +1

    big THANKS!

  • @bikertejas7987
    @bikertejas7987 2 года назад +1

    Is there any way to sort order based upon measure values ?

  • @gosiaciszewska7085
    @gosiaciszewska7085 2 года назад +1

    Great video. Problem solved!! Thanks a lot :)

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

    It's working perfect, but for this chart. I tried same approach in donut chart - didn't work. Any ideas how to do the same for donut chart?

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

    Thanks mate👌

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

    Thank you!

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

    Thank's for the video, why don't add a custom column based on if or switch statement ,for each sales person you add an id instead of creating a table and add relationship with the current one?

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

      Hi, I just tried that and I got a "Circular dependency" error message.

    • @00snowball00
      @00snowball00 Год назад

      you can do that, I usually don´t create a new table if the values sorted will be used only in one table, I make one column for the order (with switch), but then you have to make a copy of column you want to sort and you sort that one (otherwise you get circular dependency eror)

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

      @@00snowball00 I understand. Still, the idea of two columns to achieve that doesn't seem attractive. I'm just being thick at thispoint.
      What I finally did was to create just one sorter table for all and any custom sorter, and add different columns for each join. I think I also had to fill the blanks with "Other" to avoid errors. It felt more organized to me.

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

    Hello if I want compare two years how to do with stack bar chart?

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

    how about sort by value dynamically? say from largest to smallest

  • @SGgoofy
    @SGgoofy 4 года назад

    Hi, why does the data in the new sort order column is not complete after i have created it

    • @GeekDecodersPowerBILearning
      @GeekDecodersPowerBILearning  4 года назад

      You means there are Null values right? Please check whether you have included all the names there.