Conditional Format Gauge Charts

[JoseDavidM]

HI, i have a simple question, how can established a conditional format in a gauge chart based on a mobile target?, i mean, i have a diferent target every week and i need that the graph change between green and red depending on that

[v-robertq-msft · Accepted solution]

Hi, @JoseDavidM 

According to your requirement, I think that you can create another measure to compare the value of the two measures based on the slicer. You can try this method:

1. Create a measure:

Color = IF([Percent]<[Target1],"Red","Blue")

2. Create a gauge chart and set the data color like this:

3. Then create a slicer to slice the data based on week number, and you can get what you want, like this:

You can download my test pbix file here

If this result is not what you want, you can post some sample data(without sensitive data) and your expected result.

How to Get Your Question Answered Quickly 

Best Regards,

Community Support Team _Robert Qin

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[selimovd]

Hey @JoseDavidM ,

you can change the conditional format based on a measure.

And the measure can change every week based on your data.

To to the format settings of you Gauge visual and click to the function symbol next to the target color:

Then you can chose the colors based on a measure:

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

[selimovd]

Hey @JoseDavidM ,

did it work with the measure in the conditional formatting?

I'm curious if you could solve this issue 🙂

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

[JoseDavidM]

Thanks for the answer. actually my problem is that the rule of the conditional format depends of two fields or measures, i mean, i need that tha graph change to red when a measure is lowe thatn another measure (target).