Forum Discussion

JoseDavidM's avatar
JoseDavidM
Helper I
5 years ago
Solved

Conditional Format Gauge Charts

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...
Need Help
  • v-robertq-msft's avatar
    v-robertq-msft
    5 years ago

    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")
    1. Create a gauge chart and set the data color like this:

     

    1. 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's avatar
selimovd
Most Valuable Professional
5 years ago

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
 
  • selimovd's avatar
    selimovd
    Most Valuable Professional
    5 years ago

    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
     
    • JoseDavidM's avatar
      JoseDavidM
      Helper I
      5 years ago

      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).