topic Re: Conditional Formatting using 2 Text Columns in DAX Commands and Tips

Conditional Formatting using 2 Text Columns

ladeko — Wed, 18 Oct 2023 22:45:51 GMT

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. 😊

Re: Conditional Formatting using 2 Text Columns

Dangar332 — Thu, 19 Oct 2023 07:03:49 GMT

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.

Re: Conditional Formatting using 2 Text Columns

ladeko — Thu, 19 Oct 2023 12:22:00 GMT

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