Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
leroy773
Helper II
Helper II

KPI target value is inversed.

‎10-18-2016 01:03 PM

I am currently working with a KPI visualization.  I have my data table and created another table for the target.  Unfortunately, the KPI results are inversed.  My target is 3, and anything lower than 3 is ideal.  Currently my KPI shows anything lower than 3 as red and anything higher then 3 as green.  Appears the KPI believes anything above 3 is good.  Is there a way to change it so KPI sees anything above 3 as red?

Labels:
Message 1 of 4
1,446 Views
0
2 ACCEPTED SOLUTIONS
BhaveshPatel
Community Champion
Community Champion

‎10-18-2016 01:40 PM

You can change the settings as per the screenshot to view the ideal results.

 

KPI color.PNG

Thanks & Regards,
Bhavesh

Love the Self Service BI.
Please use the 'Mark as answer' link to mark a post that answers your question. If you find a reply helpful, please remember to give Kudos.

View solution in original post

Message 3 of 4
1,854 Views
0
leroy773
Helper II
Helper II
In response to BhaveshPatel

‎10-18-2016 01:42 PM

Thanks so much, I thought I looked at everything in the format section.

View solution in original post

Message 4 of 4
1,777 Views
0
3 REPLIES 3
BhaveshPatel
Community Champion
Community Champion

‎10-18-2016 01:40 PM

You can change the settings as per the screenshot to view the ideal results.

 

KPI color.PNG

Thanks & Regards,
Bhavesh

Love the Self Service BI.
Please use the 'Mark as answer' link to mark a post that answers your question. If you find a reply helpful, please remember to give Kudos.
Message 3 of 4
1,855 Views
0
leroy773
Helper II
Helper II
In response to BhaveshPatel

‎10-18-2016 01:42 PM

Thanks so much, I thought I looked at everything in the format section.

Message 4 of 4
1,778 Views
0
Vvelarde
Community Champion
Community Champion

‎10-18-2016 01:40 PM

hi @leroy773

 

Change the direction of Good:

 

kpi color.png




Lima - Peru
Message 2 of 4
1,438 Views
0

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

View All
Top Solution Authors
View All
Top Kudoed Authors
View All