Forum Discussion
conditional formatting not working on measure
I'm trying to put a range conditional format with colors on the following visual. The MH CPOE % value is a measure and it does not have the option to have conditional formatting. I need to make the facilities that are under 80% RED, the ones under 85% Yellow, and the ones above 85% GREEN.
Can someone help me figure this out?
Hi Anonymous,
You need to set the color formatting under data color of format:
And you will see:
For the related sample .pbix file,pls see attached.
You may also check the blog below for reference:
https://radacad.com/sentiment-colors-for-gauge-visual-in-power-bi
Best Regards,
KellyDid I answer your question? Mark my post as a solution!
14 Replies
- Ashish_Mathur
Super User
Hi,
Share the link from where i can download your PBI file.
v-kelly-msftCommunity Support
Hi Anonymous,
You need to set the color formatting under data color of format:
And you will see:
For the related sample .pbix file,pls see attached.
You may also check the blog below for reference:
https://radacad.com/sentiment-colors-for-gauge-visual-in-power-bi
Best Regards,
KellyDid I answer your question? Mark my post as a solution!
