Highlight Weekends in Graphs

[Anonymous]

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 hierarchy" with "Show empty elements" to visualy see days when there is nothing going on.

The down side of the "show empty elements" is that there is no work on Saturday and Sunday.

It would be pretty cool if the Weekends could be color coded to show at first glance that the machine isn't empty but "closed" something like this, or similar.

Anyone has an idea on how to do this?

Regards.

[Anonymous]

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?

[ribisht17]

@Anonymous 

You can do something similar

https://community.powerbi.com/t5/Desktop/Line-Chart-to-highlight-Weekends/m-p/2127132

Regards,

Ritesh