Conditional Formatting using 2 Text Columns

[ladeko]

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 "Not Reported Timely" then I want to highlight the 2nd column in YELLOW if the 2nd columns shows as blank. The second column is "The reason it was not reported timely". 

Column 1 Name = Eform Reported Timely by Sumbitter

Column 2 Name = Submitter Timeliness Explained

THIS IS WHAT I NEED IT TO DO:

• I only need the ones highlighted in YELLOW if the 1st column says "Not Reported Timely" AND the 2nd column is blank.
• So if column 1 says "Not Reported Timely" AND column 2 is BLANK, then I need the background in column 2 to be highlighted in the color YELLOW.

Truly appreciate any assistance you can provide. 😊

[Dangar332 · Accepted solution]

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]

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