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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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
Employee
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
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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