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.
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.
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
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/
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
61 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |