Color Code for table visual

[PGY]

Dear experts,

I have 2 datasets - that I would like to display in a single table visual.

Dataset 1 - has all the IDs  and also a calculated field (colorcode-days) that I used as to color the timeline column. (0 red, 1 yellow, 2 no color)

Dataset2 - only has some of the IDs (ID 1-4) where some IDs can have more than 1 rows

(e.g.: Row1 : ID1 activity 1; Row2: ID2, activity 2, ...)

There was a key to connect dataset 1 and dataset 2.

When I put columns from dataset1 only, the color on timeline column works just fine. However, when I included columns from dataset2, only the common IDs on both datasets have the timeline color.

(Note: ID5,7 and 10 - lose their timeline color after I added Grade column from dataset2).

Would you please kindly advise how to solve this?

[v-jingzhang]

Hi @PGY 

I did a test. If [Grade] field in the table visual is aggregated no matter using Sum/Average/Maximum/Minumum..., the conditional color works well.  

However, if using "Don't summarize" for Grade field in the table visual, the colors are not correct. From the table visual, you can find that "Sum of Color-Code-Days" field is not working like before and its result is different from that in "ColorCode-Days" field which is not summarized. This is because when the "Grade" field is not summarized, it will pass a filter to other fields in the same table visual. For non-summarized fields, it seems not affected. But for measures and aggregated fields, this filter will affect their results. 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.