Forum Discussion

Nicki's avatar
Nicki
Helper III
5 years ago

Correct values when there is a relation between two tables

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

Need Help

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    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's avatar
      Nicki
      Helper III
      5 years ago

      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