The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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!
Solved! Go to 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
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
Thanks so much for your time!
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...