Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
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 @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
Look into using a Deneb visual for that. Gives you more flexibility with the mark colors.
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