So what happens when you put User Activity Status on color?
OK, there is no way to selectively color headers. If you can find a way to move those shapes into the cells itself this might be doable. Is there a 'Measure Names' card you are using where you can drag-and-drop the 'User Activity Status' into? Or are all the weeks columns part of a single dimension?
In any case, I see two alternatives here.
1. If Activity data is important, coloring whole rows like that would probably be the most salient way to represent that information for the user. What problems do you foresee with leaving it exactly like that in your last screenshot?
2. Coloring the shapes in addition to having different shapes really doesn't add anything for the user. I am wondering whether trying to add color is a useful endeavor after all.
thanks for your prompt reply. Really appreciate it:)
Yes, the week columns are part of a single dimension & I am not using a measure names column to drag and drop the User Activity
For your questions 1 and 2 below is the business requirement and what I have currently in my worksheet
Current Worksheet that I have