In order to help you better, can you post the workbook?
please check attached.. i'd like to color all the columns by weekday where weekday = "mon".. i created a calculated filed color code = IF [Weekday] = 'Mon' then 1 else 0 end
but it doesnt color all the fields..
how do u attach the workbook? am i supposed to use the viz link? can u please tell me the steps?
The issue here is that only the PY_MESSAGE field is on the text shelf which is the mark. The color shelf only applies to the marks. Jonathan Drummey's blog post should give you some guidance on ways around this:
Another option would be to create multiple worksheets, colored in the desired way, and place them on a dashboard together.
Hope this helps!