Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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

 

 

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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?