Forum Discussion
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 "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. 😊
HI , ladeko
Follow below steps
make mesureresult =IF(max('condition'[Column1])="b"&& max('condition'[Column2])= BLANK(),"#FFFF00")1. go to column 2 right click and choose conditional formating shown as below2. choose formate style value to field value and .3. choose result(measure name ) from field should we based onand press ok you get your answerhere 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.
2 Replies
HI , ladeko
Follow below steps
make mesureresult =IF(max('condition'[Column1])="b"&& max('condition'[Column2])= BLANK(),"#FFFF00")1. go to column 2 right click and choose conditional formating shown as below2. choose formate style value to field value and .3. choose result(measure name ) from field should we based onand press ok you get your answerhere 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.
