topic Conditional Formatting based on one column that contains string value in DAX Commands and Tips

Conditional Formatting based on one column that contains string value

kalkhudary — Thu, 17 Aug 2023 20:49:58 GMT

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

OwenAuger

Any thoughts on best solution.

Re: Conditional Formatting based on one column that contains string value

vicky_ — Thu, 17 Aug 2023 23:25:33 GMT

Create a measure, and format based on that:

formatting = IF(SELECTEDVALUE('Table'[Project Code]) = "", 1).

Re: Conditional Formatting based on one column that contains string value

kalkhudary — Thu, 17 Aug 2023 23:39:48 GMT

Can you please explain steps.