Forum Discussion

gendat's avatar
gendat
New Member
8 years ago

Weekend highlighting line chart

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.   ...
Anonymous's avatar
Anonymous
Not applicable
8 years ago

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