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.

amitchandak's avatar
amitchandak
Super User
4 years ago

PThompson1888 , Not able to get the logic. But this logic if you can create a measure, then you can use that in conditional formatting using field value option

 

example

 

Switch( True() ,
[Percent] =1 , "Green"
[percent] <.75 , "red",
[percent] <.99 , "Yellow"
)

 

How to do conditional formatting by measure and apply it on pie?: https://youtu.be/RqBb5eBf_I4

PThompson1888's avatar
PThompson1888
Regular Visitor
4 years ago

Hi amitchandak - I have tried to make my logic more clear by updating my initial post. The criteria I would have are 'AND' rather than having the suggestion above which would only take into account one column in my data (margin percent). 

Does the updated post clarify a little on what I am trying to do?