Forum Discussion

ladeko's avatar
ladeko
Regular Visitor
2 years ago
Solved

Conditional Formatting using 2 Text Columns

I would like to create a DAX formula that will compare one column to another. I have a table. Column 1 has 2 items:  It will either say "Reported Timely" OR "Not Reported Timely". If the item says "N...
  • Dangar332's avatar
    Dangar332
    2 years ago

    HI , ladeko 

    Follow below steps

    make mesure 

    result =
    IF(max('condition'[Column1])="b"&& max('condition'[Column2])= BLANK(),"#FFFF00")
     
    1. go to column 2 right click and choose conditional formating shown as below 
     
    2. choose formate style value to field value and .
     3. choose result(measure name ) from field should we based on 
    and press ok you get your answer 

     

    here the same scenario but with different data

     

     

    for more related to this topic visit HERE 

     

    If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.

Dangar332's avatar
Dangar332
Resident Rockstar
2 years ago

HI , ladeko 

Follow below steps

make mesure 

result =
IF(max('condition'[Column1])="b"&& max('condition'[Column2])= BLANK(),"#FFFF00")
 
1. go to column 2 right click and choose conditional formating shown as below 
 
2. choose formate style value to field value and .
 3. choose result(measure name ) from field should we based on 
and press ok you get your answer 

 

here the same scenario but with different data

 

 

for more related to this topic visit HERE 

 

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.

  • ladeko's avatar
    ladeko
    Regular Visitor
    2 years ago

    And you are a genius!!! Thank you. You just helped me become more productive at work. I can now take a manual, tedious Excel process that would take me about 6 hours and now turn that process into literally 5 minute refresh using Power BI and the measure you gave me. THANK YOU Dangar332