Forum Discussion
Line Chart to highlight Weekends
Hi All, I'm working on a project to see the number of users that visit our website, shown as a line graph over time. I noticed that there fewer numbers that visit our site on weekends than during...
I've figured it out.
- I had to amend my formula to (see snipet). If the weekend (days numbered 5 or 6) then count the total number users otherwise leave blank
WeekDayWeekEnd = SWITCH('Contact Us Page'[Day of Week],5,SUMX('Contact Us Page','Contact Us Page'[Users]),6,SUMX('Contact Us Page','Contact Us Page'[Users]))- I needed to change the chart type to Line and Column Chart. Then add the abouve formula to the bar chart field.
- A few other edits to the visualisation to make it look "pretty"
I've figured it out.
- I had to amend my formula to (see snipet). If the weekend (days numbered 5 or 6) then count the total number users otherwise leave blank
WeekDayWeekEnd = SWITCH('Contact Us Page'[Day of Week],5,SUMX('Contact Us Page','Contact Us Page'[Users]),6,SUMX('Contact Us Page','Contact Us Page'[Users]))
- I needed to change the chart type to Line and Column Chart. Then add the abouve formula to the bar chart field.
- A few other edits to the visualisation to make it look "pretty"