Conditional formatting not functioning as expected on calculated columns

[appsac1]

It seems to me that conditional formatting does not work as expected on calculated columns. 

How do you work around that? 

[v-zhangti · Accepted solution]

Hi, @appsac1 

You can try the following methods.

Sample data:

Measure color = IF(SUM('Table'[Value])<=50,"Green","Red")

Result:

This adds conditional formatting to the calculation column. If it doesn't solve your problem, please provide sample data and desired output.

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@appsac1 , Need example what is not working.

Conditional formatting works best when a measure drives it (Gradient/rule or field)

Learn Power BI Advance - PowerBI Abstract Thesis:
How to do conditional formatting by measure and apply it on pie?
https://www.youtube.com/watch?v=RqBb5eBf_I4&list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8L
https://community.powerbi.com/t5/Community-Blog/Power-BI-Conditional-formatting-the-Pie-Visual/ba-p/...
https://amitchandak.medium.com/power-bi-where-is-the-conditional-formatting-option-in-new-format-pan...

The information you have provided is not making the problem clear to me. Can you please explain with an example.

Appreciate your Kudos.