topic Re: WeekDay Sort on Column chart in Desktop

WeekDay Sort on Column chart

Anonymous — Wed, 25 Nov 2020 05:30:34 GMT

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

Re: WeekDay Sort on Column chart

veenashenolikar — Wed, 25 Nov 2020 05:46:56 GMT

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

Re: WeekDay Sort on Column chart

Anonymous — Wed, 25 Nov 2020 05:56:11 GMT

Hi veenashenolikar

I did that. But it did not work. Its is sorting weekday based on the value.

Re: WeekDay Sort on Column chart

amitchandak — Wed, 25 Nov 2020 05:59:59 GMT

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

Re: WeekDay Sort on Column chart

Anonymous — Wed, 25 Nov 2020 06:02:12 GMT

amitchandak - I do not have a date column. I only have 2 columns weekday & value.

Re: WeekDay Sort on Column chart

amitchandak — Wed, 25 Nov 2020 06:12:24 GMT

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

Re: WeekDay Sort on Column chart

veenashenolikar — Wed, 25 Nov 2020 06:40:13 GMT

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

Re: WeekDay Sort on Column chart

Anonymous — Wed, 25 Nov 2020 15:31:13 GMT

Hi veenashenolikar -
Yes I tried the same way. But its not working.

Re: WeekDay Sort on Column chart

Anonymous — Wed, 25 Nov 2020 15:35:52 GMT

amitchandak - Thanks. It works.