Skip to main content
cancel
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
kalpanaV
Helper IV
Helper IV

KPI

Capture.PNG

If it is greater than 90%, i want to display in green color. if it is between 80 to 90%, i want to display in amber color. please help me on this.

5 REPLIES 5
v-yulgu-msft
Microsoft Employee
Microsoft Employee

Hi @kalpanaV,

 

Currently, it is not supported to specify different colors for each category, in other words, set row color based on specific value.

 

Regards,
Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
fhill
Resident Rockstar
Resident Rockstar

 

Have you tried a Confitional Formatting:  (In the most recent Power BI Dekstop version, you have to pick 'Color Scales' after Conditional Formatting, but the rest of this document should help?)

 

https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-conditional-table-formatting/




Did I answer your question, or help you along the way?
Please give Kudos or Mark as a Solution!


https://www.linkedin.com/in/forrest-hill-04480730/

Proud to give back to the community!
Thank You!




Hi 

 

Thank you, i read this document. but the thing is , i want to mention greater than or less than in numbers.. ie particular no i want to give.

What i want is 

if it is greater than 95%, it should be in green color.

if it is between 85% to 95%,it should be in amber color.

if it is below 85%, it should be in red color.

Hi @kalpanaV,

 

I can understand your requirement. You want to set the background of cell or row conditionally based on percentage value, right? Unfortunately, this is not supported now.

 

Regards,
Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

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

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

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.