Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Colour Saturation

Hi Experts

 

I am using a clustered bar chart for the vuisulaisation and i cannot find the colour stauration field, so my postive values are being shown as red as opposed to green variance.

see image below.

 

3 Replies

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee

    Hi Anonymous,

     

    You could add a calculated column like below.

    Column3 = IF(Table2[Column2]>0,1,0)

     

    Add the calculated column into chart legend. You can customize the color for column bars under "Data Colors".

    Best regards,

    Yuliana Gu

    • Anonymous's avatar
      Anonymous
      Not applicable
      Hi Gu. Thanks for the feedback. But it's a live connection from Cube. Cannot add said column. Hence my problem.