topic Re: Conditional Format Blank Values for Specified Column in DAX Commands and Tips

Conditional Format Blank Values for Specified Column

TJK — Fri, 12 Jul 2024 13:18:18 GMT

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?

Re: Conditional Format Blank Values for Specified Column

BeaBF — Fri, 12 Jul 2024 13:24:15 GMT

TJK Hi! Can you share the pbix?

Re: Conditional Format Blank Values for Specified Column

TJK — Fri, 12 Jul 2024 13:40:09 GMT

BeaBF Hi! Please download the file here:

https://www.dropbox.com/scl/fi/a7haz9hsn9plo08xj3q3v/Market-Share-v4.pbix?rlkey=0bk7nop88f73vjtpxiw6x3wcr&st=oiy8mg3r&dl=0

Re: Conditional Format Blank Values for Specified Column

BeaBF — Fri, 12 Jul 2024 14:11:42 GMT

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

Re: Conditional Format Blank Values for Specified Column

TJK — Fri, 12 Jul 2024 14:22:03 GMT

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?

Re: Conditional Format Blank Values for Specified Column

BeaBF — Fri, 12 Jul 2024 14:28:56 GMT

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