Forum Discussion
How to setup color code for date value
hello Anonymous
here is the table that might be closer to your table.
do you accept visual like this?
since this is matrix, or else using table visula will be look like this.
if you good with either of those two, the process is same as above (unpivot those date tables)
Thank you.
Thank you Chew_WenJie and Irwan I knew about create new measure, just I need to track lot of columns which are all date value(request date, approval date, start date, complete date, test date, accept date....), I just don't want to create so many measures for each one.
hello Anonymous
if you dont want to create multiple measure and multiple color assignment, i would unpivot all those date column and use matrix visual instead of table visual.
1. i assumed you have another column to differentiate those date such as ID
2. unpivot that table so you will have only one date column
3. plot into matrix visual
4. assign color measure to date column (from Cell Elements)
5. the rest is same as above.
Hope this will help.
Thank you.
Thank you thank you Irwan and appreciate your time. I am with you on the logic. Just my raw data is already in this way as your picture and the "ID" is consisted with multi several columns as 2nd picture.
hello Anonymous
here is the table that might be closer to your table.
do you accept visual like this?
since this is matrix, or else using table visula will be look like this.
if you good with either of those two, the process is same as above (unpivot those date tables)
Thank you.