Conditional Format Blank Values for Specified Column

[TJK]

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?

[BeaBF]

@TJK Hi! Can you share the pbix?

[TJK]

@BeaBF Hi! Please download the file here:

https://www.dropbox.com/scl/fi/a7haz9hsn9plo08xj3q3v/Market-Share-v4.pbix?rlkey=0bk7nop88f73vjtpxiw6...

[BeaBF]

@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

[TJK]

Yes I think I understand. If I create placeholder values for the borrowers and then filter those values out of my matrix, can I then achieve the desired result?

[BeaBF · Accepted solution]

@TJK yes, you need to have the same grantors in both tables so that a correspondence is created and you can have the cell as blank but matched.

BBF