Forum Discussion
Background Color Change based upon Value
Unfortunately, to the best of my knowledge, conditional formatting does not work on text columns/measures, only numeric.
One way that you might be able to achieve this would be to create a measure that returns 1 if "Compliant" and 0 if "Not Applicable". Create a matrix visualization setup the exact same way as your other matrix visualization except use this new measure as a replacement for your other matrix/column. Now, make the Value text size as small as possible. Place this matrix exactly behind your original matrix. Make sure that your original matrix has transparency set to something other than 0%.
Hacky, but that's the best thing I can think of.
When you are all done, go vote for this Idea: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/32184037-conditional-formatting-for-text
I just did.
Unfortunately, to the best of my knowledge, conditional formatting does not work on text columns/measures, only numeric.
One way that you might be able to achieve this would be to create a measure that returns 1 if "Compliant" and 0 if "Not Applicable". Create a matrix visualization setup the exact same way as your other matrix visualization except use this new measure as a replacement for your other matrix/column. Now, make the Value text size as small as possible. Place this matrix exactly behind your original matrix. Make sure that your original matrix has transparency set to something other than 0%.
Hacky, but that's the best thing I can think of.
When you are all done, go vote for this Idea: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/32184037-conditional-formatting-for-text
I just did.
It Worked Perfectly!!!
Thanks
Deepak
