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 competit...
Need Help
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,

     

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      For only one factor, your formula works great, but as i told, there are 3 more factors, Gold-Silver-Bronze, do you have any idea about it ?

      • v-zhangti's avatar
        v-zhangti
        Community Support
        4 years ago

        Hi, Anonymous 

         

        Unfortunately, power BI is now unable to achieve what you need . You can submit an idea for it at https://ideas.powerbi.com/forums and wait for users with the same needs as you to vote for you to help make it happen as soon as possible.

         

        Best Regards,

        Community Support Team _Charlotte

        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.