Forum Discussion
Highlight Weekends in Graphs
Greetings, I'm using a stapled bar Chart to display how much Work we have to do per Day. On the X axis there are Dates with Values, some of them stack. All of that is used as "date ...
Okay... that does seem like what i'm looking for, thanks.
Now how would one properly enter this formula?
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 assume creating a new measure with those values should work?
Thats the only way i can open this "edit" field.
DataWeekEnd = SWITCH('pb_pps_data plan_step_attrs'[production_date],5,SUMX('pb_pps_data plan_step_attrs','pb_pps_data plan_step_attrs'[production_time]),6,SUMX('pb_pps_data plan_step_attrs','pb_pps_data plan_step_attrs'[production_time]))
but for some reason it doesnt work...
i assume thats because i'm missing the "day of week" value that would allow me to find Weekends?