Forum Discussion
WeekDay Sort on Column chart
Hi All,
I have the below sample data. When I created column chart with weekday on X-axis & Value on Y-axis. I am not able to order the weekday with actual day of the week order i.e monday, tuesday, wednesday....Holiday. I tried creating new column with switch DAX but its not working. I am getting below result on PBI. Can you please help to sort?
| WeekDay | Value |
| Monday | 5 |
| Friday | 4 |
| Saturday | 3 |
| Tuesday | 6 |
| Wednesday | 1 |
| Thursday | 8 |
| Sunday | 9 |
| Holiday | 2 |
Thanks
Anonymous , if you have date in table create a sort column
Weekday = weekday([date])
Weekday1 = weekday
weekday sort = Switch( True(),
[Weekday]= "Monday" ,1 ,
//Add others
8//default value
)
And sort weekday 1 on weekday sort
https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column
else create
Anonymous , Then refer to my second option
Weekday1 = weekday
weekday sort = Switch( True(),
[Weekday]= "Monday" ,1 ,
//Add others
8//default value
)
And sort weekday 1 on weekday sort https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-sort-by-column
8 Replies
veenashenolikarHelper V
Anonymous ,
You need to sort the WeekDay column using Value column. There is a option to do so in Data View.
After that, sort your chart on Weekday.(Check descending/ascending as per your requirement)
Please mark this as a solution if it help you solve your issue.
Regards,
Veena Shenolikar
- veenashenolikar
Hi Anonymous ,
You need to change the sorting of the chart from Values to Weekday column. Have you tried this?
Mark this as a solution if it helped solve your issue.
Veena Shenolikar
- amitchandak
Super User
Anonymous , if you have date in table create a sort column
Weekday = weekday([date])
Weekday1 = weekday
weekday sort = Switch( True(),
[Weekday]= "Monday" ,1 ,
//Add others
8//default value
)
And sort weekday 1 on weekday sort
https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column
else create
amitchandak - I do not have a date column. I only have 2 columns weekday & value.
- amitchandak
Anonymous , Then refer to my second option
Weekday1 = weekday
weekday sort = Switch( True(),
[Weekday]= "Monday" ,1 ,
//Add others
8//default value
)
And sort weekday 1 on weekday sort https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-sort-by-column
amitchandak - Thanks. It works.