Forum Discussion

TJK's avatar
TJK
Helper I
2 years ago
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 t...
"DAX "
@Conditional Formatting
Conditional Formatting
DAX
  • BeaBF's avatar
    BeaBF
    2 years ago

    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

BeaBF's avatar
BeaBF
Super User
2 years ago

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's avatar
    TJK
    Helper I
    2 years ago

    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's avatar
      BeaBF
      Super User
      2 years ago

      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