Weekend highlighting line chart

[gendat]

Howto add visualization of weekends?  Best would be to colorize weekend sections the line itself.  But this method below would be helpful too.

Please refer to picture below:

Visualize weekends.

 

Thank you!

[v-yuezhe-msft]

@gendat，

If you use the ChrisHaas’s formula to create custom column, you would need to change the formula to the following:

if Date.DayOfWeekName([Date]) = "Saturday" then "Weekend" else if Date.DayOfWeekName([Date]) = "Sunday" then "Weekend" else "Weekday"


Alternatively, you can create a calculated column using DAX below. And you can create Line chart or column chart as shown in the following screenshots.

CheckWeekend = IF( OR(WEEKDAY(Table[Date])=1,WEEKDAY(Table[Date])=7),"Weekend","Weekday")



Regards,
Lydia Zhang

[Anonymous]

Add a column in Query Editor to check for weekends.

Click Add Column...Add Custom Column, and paste in the following:

if Date.NameOfDay([Date Column]) = "Saturday" then "Weekend" else if Date.NameOfDay([Date Column]) = "Sunday" then "Weekend" else "Weekday"

Then add that column as a legend to your line chart.

[gendat]

Or adding a bar like this, but coloriznig the line is prefereable.  Thanks!

[gendat]

Colorizing the line is preferable, but this bar is ok too, how to do this?