Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello Experts
How can I Change the Background Color in the following MATRIX . I want the color to be GREEN for all "Compliant" and RED for "Not Applicable. Help Please.
Thanks
Deepak
Solved! Go to Solution.
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-f...
I just did.
I may have misunderstood, or maybe Power BI has been udpated to allow conditional formatting of matrix cell background colour based on text values, but I have had success with creating a simple measure based on a single text value (A-D). I thought this
might be worth capturing here
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-f...
I just did.
It Worked Perfectly!!!
Thanks
Deepak
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
88 | |
63 |