Forum Discussion

PThompson1888's avatar
PThompson1888
Regular Visitor
4 years ago
Solved

Conditional Formatting - Multiple Criteria

Hi All,   I am currently trying to implement some conditional formatting based on 3 criteria and would really appreciate some help if possible.   The 3x columns I have: - Product Profit ($) - P...
Need Help
  • v-xiaotang's avatar
    v-xiaotang
    4 years ago

    Hi PThompson1888 

    Try this measure

    measure = 
    var _a= min('Table'[Product Profit])
    var _b= min('Table'[Parts Profit])
    var _c= min('Table'[Margin])
return 
    SWITCH(TRUE(),
    _a>0 && _b>0 && _c>0,"Green",
    _a<0 && _b>0 && _c>0,"Yellow",
    _a<0 && _b<0 && _c<0,"Red")

    Best Regards,

    Community Support Team _Tang

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

v-xiaotang's avatar
v-xiaotang
Community Support
4 years ago

Hi PThompson1888 

Try this measure

measure = 
    var _a= min('Table'[Product Profit])
    var _b= min('Table'[Parts Profit])
    var _c= min('Table'[Margin])
return 
    SWITCH(TRUE(),
    _a>0 && _b>0 && _c>0,"Green",
    _a<0 && _b>0 && _c>0,"Yellow",
    _a<0 && _b<0 && _c<0,"Red")

Best Regards,

Community Support Team _Tang

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

PThompson1888's avatar
PThompson1888
Regular Visitor
4 years ago

This worked!!

Thanks so much.