Forum Discussion

lherbert501's avatar
lherbert501
Post Prodigy
4 years ago
Solved

Percentage Range

Hi there,   I have a simple measure for a gauge that gives me the correct colour, depending on the value.   Gauge = IF([sales] >= [SalesAverage], "#00A36C","#D64550")     However, as on...
Need Help
  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    4 years ago

    Hi lherbert501 ,

    According to your description, I create a sample.

    SalesAverage is a measure.

    Now, you can tweak the Gauge measure like this:

     

    Gauge =
IF (
    INT ( MAX ( 'Table'[Sales] ) ) >= INT ( [SalesAverage] ),
    "#00A36C",
    "#D64550"
)

     

    Get the result.

    I attach my sample below for your reference.

     

    Best Regards,
    Community Support Team _ kalyj

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

v-yanjiang-msft's avatar
v-yanjiang-msft
Community Support
4 years ago

Hi lherbert501 ,

According to your description, I create a sample.

SalesAverage is a measure.

Now, you can tweak the Gauge measure like this:

 

Gauge =
IF (
    INT ( MAX ( 'Table'[Sales] ) ) >= INT ( [SalesAverage] ),
    "#00A36C",
    "#D64550"
)

 

Get the result.

I attach my sample below for your reference.

 

Best Regards,
Community Support Team _ kalyj

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