Forum Discussion
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. ...
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.