Forum Discussion
Newbie Question on Sorting Columns
Anonymous read this topic for sort by, you don't change anything on the visual, x-axis will still be the same, Week Name
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡
Anonymous yes you are on right track you can add weekday column by using following expression
Weekday Number = WEEKDAY ( DateTable[Date] )
select Day column and on the menu under column tools, sort it by weekday number column that created from the above expression and that will do it
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡
Great!
One last question, please. So now I have the data sorted by Weekday number. I would like the X axis labels to appear as the Alpha Date Name rather than the number. How can I do that, please?
Thanks again.
Anonymous read this topic for sort by, you don't change anything on the visual, x-axis will still be the same, Week Name
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡
That is absolutely it!
Thanks so much!!!!!
Sincerely,
Erin