Conditional formatting for difference between bars?

Hi kowas2,

Check out below solution which is a workaround as directly adding Cumulative Attrition % and Target % to the clustered column chart will not enable conditional formatting or can show conditional formatting for only diff%.

Create two measures - Attrition % (Less) and Attrition % (More) - It helps to show less % bar as green and more % bar as red. 

Attrition (Less) = IF(SUM(Table1[Cumulative Attrition %])<= SUM(Table1[Target %]), SUM(Table1[Cumulative Attrition %]))

Attrition (More) = IF(SUM(Table1[Cumulative Attrition %])> SUM(Table1[Target %]), SUM(Table1[Cumulative Attrition %]))

Add these two measures along with Target % to clustered chart.

Go to Visual Formatting > Columns > Choose Series > Choose each field and select colour for each of them.

Check below example for Attrition Less

Then, in Columns > Choose Series - All > Layout > Modify changes as below to align the bars accordingly. 

Result - 

💡 Helpful? Give a Kudos 👍 — keep the community growing
✅ Solved your issue? Mark as Solution ✔️ — help others find it faster

Best regards,
Rupasree Achari | BI & Fabric Analytics Engineer