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!
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!
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 is so needlessly complicated but thanks for your help!
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!
This video was exactly what I needed and everything was explained very well! Thank you for the content
Thank you.
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 😊
that's so awesome - thanks for this tutorial for custom legend sorting
Great explanation. I wonder if we can create the table within the calculated column code and spare the unused table.
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!
This video is excellent - thank you!
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
Very helpful and it worked smoothly.. thanks a lot for this wonderful session
This was a perfect video, thank you very much for making it so concise!
My pleasure
You have fulfilled the prophecy!
Thank you so much. This is incredibly helpful even to this day!
Exactly what I needed! Thank you.
My pleasure
Does this work for controlling sort order in a Stacked Area chart?
Many thanks, really useful
My pleasure
Saved my life! Thank you my friend!
thanks. simply helpful!
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!
Thank you, helped a lot.
Is there any way to sort order based upon measure values ?
big THANKS!
My pleasure
Excellent video! Thanks
Thanks
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 man, appreciate it :)
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.
Great video. Problem solved!! Thanks a lot :)
My pleasure.
is the both directional relation necessary?
Thanks bro, was helpful!!
My pleasure.
Thank you!
Thanks mate👌
My pleasure.
Hello if I want compare two years how to do with stack bar chart?
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.
how about sort by value dynamically? say from largest to smallest