conditional formatting not working on measure

[Anonymous]

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?

[Ashish_Mathur]

Hi,

Share the link from where i can download your PBI file.

[Anonymous]

I can't share the file unfortunately

[Syndicate_Admin]

Don't @mrizvi,

You must set the color format to format the color of the data:

And you'll see:

For the related example .pbix file, see Attachments.

You can also check the blog below for reference:

https://radacad.com/sentiment-colors-for-gauge-visual-in-power-bi

Saludos
Kelly

Did I answer your question? Mark my position as a solution!

[Syndicate_Admin]

Don't @mrizvi,

You must set the color format to format the color of the data:

And you'll see:

For the related example .pbix file, see Attachments.

You can also check the blog below for reference:

https://radacad.com/sentiment-colors-for-gauge-visual-in-power-bi

Saludos
Kelly

Did I answer your question? Mark my position as a solution!

[Syndicate_Admin]

Don't @mrizvi,

You must set the color format to format the color of the data:

And you'll see:

For the related example .pbix file, see Attachments.

You can also check the blog below for reference:

https://radacad.com/sentiment-colors-for-gauge-visual-in-power-bi

Saludos
Kelly

Did I answer your question? Mark my position as a solution!

[Syndicate_Admin]

Don't @mrizvi,

You must set the color format to format the color of the data:

And you'll see:

For the related example .pbix file, see Attachments.

You can also check the blog below for reference:

https://radacad.com/sentiment-colors-for-gauge-visual-in-power-bi

Saludos
Kelly

Did I answer your question? Mark my position as a solution!

[Syndicate_Admin]

Don't @mrizvi,

You must set the color format to format the color of the data:

And you'll see:

For the related example .pbix file, see Attachments.

You can also check the blog below for reference:

https://radacad.com/sentiment-colors-for-gauge-visual-in-power-bi

Saludos
Kelly

Did I answer your question? Mark my position as a solution!

[Syndicate_Admin]

Don't @mrizvi,

You must set the color format to format the color of the data:

And you'll see:

For the related example .pbix file, see Attachments.

You can also check the blog below for reference:

https://radacad.com/sentiment-colors-for-gauge-visual-in-power-bi

Saludos
Kelly

Did I answer your question? Mark my position as a solution!

[Syndicate_Admin]

Don't @mrizvi,

You must set the color format to format the color of the data:

And you'll see:

For the related example .pbix file, see Attachments.

You can also check the blog below for reference:

https://radacad.com/sentiment-colors-for-gauge-visual-in-power-bi

Saludos
Kelly

Did I answer your question? Mark my position as a solution!

[Syndicate_Admin]

Don't @mrizvi,

You must set the color format to format the color of the data:

And you'll see:

For the related example .pbix file, see Attachments.

You can also check the blog below for reference:

https://radacad.com/sentiment-colors-for-gauge-visual-in-power-bi

Saludos
Kelly

Did I answer your question? Mark my position as a solution!

[Syndicate_Admin]

Don't @mrizvi,

You must set the color format to format the color of the data:

And you'll see:

For the related example .pbix file, see Attachments.

You can also check the blog below for reference:

https://radacad.com/sentiment-colors-for-gauge-visual-in-power-bi

Saludos
Kelly

Did I answer your question? Mark my position as a solution!

[Syndicate_Admin]

Don't @mrizvi,

You must set the color format to format the color of the data:

And you'll see:

For the related example .pbix file, see Attachment.

You can also check the blog below for reference:

https://radacad.com/sentiment-colors-for-gauge-visual-in-power-bi

Saludos
Kelly

Did I answer your question? Mark my position as a solution!

[Syndicate_Admin]

Don't @mrizvi,

You must set the color format to format data color:

And you'll see:

For the related example .pbix file, pls see Attachment.

You can also check the blog below for reference:

https://radacad.com/sentiment-colors-for-gauge-visual-in-power-bi

Saludos
Kelly

Did I answer your question? Mark my position as a solution!

[v-kelly-msft · Accepted solution]

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,
Kelly

Did I answer your question? Mark my post as a solution!