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.

 

 

 

Thank you!

 

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    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's avatar
    gendat
    New Member
    8 years ago

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

    • gendat's avatar
      gendat
      New Member
      8 years ago

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

  • 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