Correct values when there is a relation between two tables

[Nicki]

Hello, I have two tables  and there is a relation between them on the code column. 

When I want to use HexColorCode to show the color in stacked column chart, it brings the first color (yellow) for both city.

Dataset for chart is city table but I want to show the color.

Thank you for any idea.

Code	HexColorCode
1	#F2C80F(yellow)
2	#8AD4EB(Blue)

Code	City	Total Events/Year
1	XXXX	20
2	ZZZZZ	40

[amitchandak]

@Nicki , Stacked column visual(with legend do not support conditional formating.

I think the bar with more than one axis and one measure can do.

You can use measure max(Table1[HexColorCode])

in conditional formatting with field value option

[Nicki]

Thank you for reply. My Stacked  chart does not have legend and I have already used conditional formating.

It happens when I am using a column from another dataset. If I bring the HexColorcode column inside of city table it works fine.

I am thinking maybe I missed something related to relation setting.

Nicki