Conditional Formatting Stacked Column

[Anonymous]

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.

[Arul]

@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]

It doesnt work 😞

and i have to problem 

1) country color

2) medals shading according to country.

[Arul]

@Anonymous ,

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

set your measure like this,

[Anonymous]

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]

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.