Forum Discussion
Solved
Conditional Format Blank Values for Specified Column
I am trying to create a DAX formula to conditionally format the blank values for a specified column.
In the below visual, I want all the blank values under "Renovo", "6/24", and "%" to show as the trianglelow icon.
Below is my formula:
Color =
IF(
SELECTEDVALUE('Transactions Export'[Previous Month Filter])="Previous Month" && SELECTEDVALUE('Transactions Export'[Lender v3])="RENOVO" && ISBLANK([Transactions %]),"TriangleLow")
No icons appear with my formula. How can I acheive the desired result?
5 Replies
BeaBF Hi! Please download the file here:
TJK
You can't achieve the desired result with the data as it is because the values for those Borrowers are missing entirely, meaning it doesn't recognize the corresponding cell, it's not just empty. You need to review the data and perform a cross join to ensure there are values for all Borrowers. Then, you can apply conditional formatting. I hope I've explained myself clearly.BBF
