Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

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
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

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