Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Vote for your favorite vizzies from the Power BI Dataviz World Championship submissions. Vote now!
Hi All,
I want to have a customize KPI visual wherein it changes depending on the category scores and targets.
I have categories wherein not all lower than goal is good or higher than goal is good. I have categories wherein a mix of categories have lower than goal is bad(e.g revenue, attendance), lower than goal is good (e.g customer complaints, costs), higher than goal is good(e.g profit, customer satisfaction), and higher than goal is bad(e.g spending, waste). My question is, how do I set-up the KPI visual to follow these for rules for each category rather than just having a fix rule for all?
If it's not possible on the KPI visual, atleast on the table form. I created table with "state column" but the results are wrong. See below for example.
Thank you!
Kind Regards,
Matt
Solved! Go to Solution.
Hi @Anonymous,
try to check this answer on a previous post.
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @Anonymous,
try to check this answer on a previous post.
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsVote for your favorite vizzies from the Power BI World Championship submissions!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
Check out the January 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 58 | |
| 53 | |
| 40 | |
| 17 | |
| 16 |
| User | Count |
|---|---|
| 116 | |
| 105 | |
| 41 | |
| 34 | |
| 25 |