Forum Discussion
kalkhudary
Helper IV
Helper IVConditional Formatting based on one column that contains string value
I have a Matrix table that includes multiple projects with their Project Code, I want to apply on the project code column conditional formatting where If I have a blank in one of the cells, it will return yellow which means code missing and if the code is there, then keep background white. Can someone help me DAX a formula that would be applicable to this case. Much appreciated. Sounds simple but my mind freezed.
| Project | Project Code |
| Project A | WS-23145 |
| Project B | |
| Project C | AB-19377 |
| Project D | FX-868599 |
| Project E | |
| Project F | PO-37383 |
| Project G | NU-93939 |
Any thoughts on best solution.
Create a measure, and format based on that:
formatting = IF(SELECTEDVALUE('Table'[Project Code]) = "", 1).
2 Replies
vicky_Super User
Create a measure, and format based on that:
formatting = IF(SELECTEDVALUE('Table'[Project Code]) = "", 1).- kalkhudary
Can you please explain steps.