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!
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!
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!
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?
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)
@@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.
After spending a few hours researching this technique is by far the easiest method when you have text fields for a Legend. Thank you!
Thank you, you released me from huge struggle!
Thank you omg. Been looking everywhere for this solution. You sir, deserve a medal.
I finally get it, thank you. I also learned something more - upvote well earned. Have a great day!
My pleasure.
This video was exactly what I needed and everything was explained very well! Thank you for the content
Thank you.
This is so needlessly complicated but thanks for your help!
that's so awesome - thanks for this tutorial for custom legend sorting
This video is excellent - thank you!
Really helpful with easy explanation. Understood somethin new today. Thank You.
My pleasure
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!
Very helpful and it worked smoothly.. thanks a lot for this wonderful session
Many thanks, really useful
My pleasure
This was a perfect video, thank you very much for making it so concise!
My pleasure
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!
Does this work for controlling sort order in a Stacked Area chart?
Great explanation. I wonder if we can create the table within the calculated column code and spare the unused table.
You have fulfilled the prophecy!
Any thoughts on sorting legends based on Sales Value instead of the custom sort?
try with Ascending/descending sorting already given when you click on 3dots on right top of the chart
Exactly what I needed! Thank you.
My pleasure
Very well explained! Thanks a lot man!
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!
Thanks man, appreciate it :)
Thank you, helped a lot.
I wasted almost an hour trying the solutions on the internet until I stumbled upon yours. Like & subscribe from me mate
Great to know that this is supportive 😊
Thanks bro, was helpful!!
My pleasure.
is the both directional relation necessary?
thanks. simply helpful!
Thank you so much. This is incredibly helpful even to this day!
Saved my life! Thank you my friend!
Excellent video! Thanks
Thanks
big THANKS!
My pleasure
Is there any way to sort order based upon measure values ?
Great video. Problem solved!! Thanks a lot :)
My pleasure.
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?
my bad. looks like it's working on donut chart as well
Thanks mate👌
My pleasure.
Thank you!
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?
Hi, I just tried that and I got a "Circular dependency" error message.
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)
@@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.
Hello if I want compare two years how to do with stack bar chart?
how about sort by value dynamically? say from largest to smallest
Hi, why does the data in the new sort order column is not complete after i have created it
You means there are Null values right? Please check whether you have included all the names there.