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!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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êsThe Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 40 | |
| 35 | |
| 34 | |
| 31 | |
| 28 |
| User | Count |
|---|---|
| 137 | |
| 102 | |
| 71 | |
| 67 | |
| 64 |