KPI and GAUGE color formatting

[i_stanescu_ro]

Hi huys

I could really use your help!

Pls note that I' using BI for just a couple of months now.

I have a KPI card and a GAUGE:

KPI CARD: VALUE is the actual, TARGET is my target and TREND AXIS is month/year

GAUGE: VALUE is the actual, TARGET VALUE is my target

capture

For the moment I have just green for met and above target and red for below target.

I would need to have this instead:

Red <85%

Orange 85-95%

Green >95%

Could you guys help me out?

Thanks so much!

[v-yangliu-msft · Accepted solution]

Hi  @i_stanescu_ro ,

I created some data:

Here are the steps you can follow：

You need to find the minimum and maximum values and then use the Switch() function to customize the colors..

GAUGE Visual:

1. Create measure.

Color =
var _mindate=MINX(ALL('Table'),[Amount])
var _maxdate=MAXX(ALL('Table'),'Table'[Amount])
var _divide=DIVIDE([Measure],_maxdate)
RETURN
SWITCH(
    TRUE(),
    _divide<0.85,"red",
    _divide>=0.85&&_divide<0.95,"orange",
    _divide>=0.95,"green")

3. Visual – Color – Fill color –fx.

3. Result:

KPI Visual:

Trend axis – fx

Best Regards,

Liu Yang

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

[i_stanescu_ro]

Thanks so much for your time!

[i_stanescu_ro]

Wow, thanks so much for this!

My issue is that I can't find the max and min of the range, because I also have a slicer for period, on months, and the data is from 2022 onwards and gets refreshed every month...