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!Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register 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êsShare feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
Check out the February 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 50 | |
| 49 | |
| 35 | |
| 15 | |
| 14 |
| User | Count |
|---|---|
| 92 | |
| 75 | |
| 41 | |
| 26 | |
| 25 |