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.
Hi Power BI Community,
I'm trying to conditionally format this table that has True/False values as well as numbers. I would like True to be highlighted in Green and False be red...while the remaining values remain neutral. Please see the image and let me know if I can provide any addtional information.
Thanks!
Solved! Go to Solution.
Hi @v-xulin-mstf, I was able to create the measure. However when I go to apply it to the column, I get the error that I "cannot convert value 'FALSE' of type Text to type Number. Is there another work around for this?
Also I tried to click through to the demo but it states that I do not have access to the sharepoint.
Thank you!
Thank you! It finally worked. I need to change the data type.
Hi Greg, OP has replied but not tagged you.
regards
Phil
Proud to be a Super User!
@geleigh Seems like that would have to be a text column so just use Conditional Formatting Rules where if the text equals "TRUE", green, "FALSE", red or otherwise black?
Hey Greg, thanks for getting back to me! This may be obvious, but it's only allowing me conditionally format based on numeric values and don't know where to find the text option.
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 |
---|---|
113 | |
97 | |
84 | |
67 | |
60 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |