WeekDay Sort on Column chart

[susheel1347]

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

[amitchandak · Accepted solution]

@susheel1347 , 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 · Accepted solution]

@susheel1347 , 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

[susheel1347]

@amitchandak - Thanks. It works.

[amitchandak · Accepted solution]

@susheel1347 , 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

[susheel1347]

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

[veenashenolikar]

@susheel1347 ,

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

[susheel1347]

Hi @veenashenolikar 

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

[veenashenolikar]

Hi @susheel1347 ,

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

[susheel1347]

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