Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Conditional Formatting Stacked Column

Hi,

 

I want to learn if it is possible to change color for each column in stacked column chart as below (I did it as an example in pic editor.)

Main goal is to show each column where the competitor is from, for example

if he/she is from USA, column will be in Blue tones,

if he/she is from Italy column will be in green tones

if he/she is from Russia column will be in red tones

Competitors from other countries will be in all grey tones.

And also that tones will be in 3 shades of the selected colors , depends on the type of medals.(gold-silver-bronze)

 

Thank you in advance.

 

 

 

 

Need Help

5 Replies

  • Arul's avatar
    Arul
    Super User
    4 years ago

    Anonymous ,

    Conditional formatting for bar is achievable but i doubt about the color shade changes for different categories.

    please refer the below,

     

    BAR CF = 
    SWITCH(TRUE(),SELECTEDVALUE(financials[Year])=2014,"Blue",
    SELECTEDVALUE(financials[Year])=2013,"#FFC200")

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      It doesnt work 😞

      and i have to problem 

      1) country color

      2) medals shading according to country.

       

       

       

      • Arul's avatar
        Arul
        Super User
        4 years ago

        Anonymous ,

        you have to use the measure in conditional formatting option setting- here 

        set your measure like this,