Can you attach a TWBX copy of your workbook?
I hope that this attached workbook help you to do what you are looking for:
I created a Day of Week calculation to show the current day like: DATENAME('weekday',[Date] )
And a conditional color like this: (I used ATTR because It is a aggregated calculation)
IF ISNULL(sum([Value])) and ATTR([Day of Week] != "Sunday") THEN
The data I loaded like you posted like :
And In tableau I pivoted and changed the names of the columns like this:
If this post answer your question, please mark as ANSWER MARKED CORRECT
Book1_v10.4.twbx 42.5 KB
Did my previous post, solve what you was looking for?
Thanks for helping me with it, Cristian!