Clustered Column Chart & Conditional Formatting

[Mario_Moubayed_]

Hello Community,

Clould anyone help me in solving my issue with the Clustered Column Chart & Conditional Formatting?
I cannot add a Conditional Formatting to a Clustered Column Chart, it's working just on Table and other visuals.
Ex: If I am comparing a Standard score with the current score by using 2 colors and I want to use a third color to highlight the scores that are below the standard, I am not able to add a condition for that and to change the column color.
Thank you in advance,
Mario

[v-binbinyu-msft]

Hi @Mario_Moubayed_ ,

Please try below steps:

1. below is my test table

Table:

2. create a measure with below dax formula

Measure =
VAR baseline = 175
VAR cur_product =
    SELECTEDVALUE ( 'Table'[Product] )
VAR cur_sale =
    CALCULATE ( MAX ( 'Table'[Sale] ), 'Table'[Product] = cur_product )
VAR _color =
    IF ( cur_sale > baseline, "green", "red" )
RETURN
    _color

3. add a cluster column chart with fields, set the column color like below

Please refer the attached .pbix file.

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Mario_Moubayed_]

Hello @v-binbinyu-msft , 
Thank you for your reply, but unfortunately it's not working with the Clustered Column Chart, it just works with the stacked Column Chart

[lbendlin]

Look into using a Deneb visual for that. Gives you more flexibility with the mark colors.

[lbendlin]

Please provide sample data that covers your issue or question completely.
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523