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: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

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,458 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,866 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,789 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,867 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,790 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,450 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