The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
User | Count |
---|---|
78 | |
74 | |
43 | |
32 | |
28 |
User | Count |
---|---|
104 | |
95 | |
51 | |
50 | |
46 |