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 workin...
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.
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 Chart
Look into using a Deneb visual for that. Gives you more flexibility with the mark colors.
