Forum Discussion
Clustered Column Chart & Conditional Formatting
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
4 Replies
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-p/963216
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/1447523Hi 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 _color3. 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.Hello Anonymous ,
Thank you for your reply, but unfortunately it's not working with the Clustered Column Chart, it just works with the stacked Column ChartLook into using a Deneb visual for that. Gives you more flexibility with the mark colors.
