Forum Discussion
Newbie Question on Sorting Columns
Hello!
I have data set with weekday data with the date (say 2020-05-04), the day of the week, and the actual values over multiple weeks.
When I select clustered column chart, the chart is sorted in numeric descending order.
Is there a way that I could sort by the day of the week, please?
Thanks,
Erin
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.⚡
10 Replies
- parry2kSuper User
Anonymous on your visual, top right corner click on 3 dots (...) and change the sort order and sort column from the menu there.
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.⚡
- AnonymousNot applicable
Great, thanks!
It is changing the sort to the day. However, it's sorting in reverse alphabetical order. Is there a way around that, please? I have a feeling that it's something very simple. Thanks!
- parry2kSuper User
Anonymous you should change the sort order descending to ascending at the same place
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.⚡