Forum Discussion
Shading chart
Hi,
I am comparing two single metric with different system and wanted to show the below chart, is it possible in Power BI? So I have Oracle Revenue has 30K and My SQL revenue as 25K and wanted to fill the cell GREEN like as I did in the screenshot and viceversa.
Thanks,
Thimma
4 Replies
- GilbertQSuper User
Hi there Anonymous
If this is in a table or matrix you can use Color Formatting: https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-conditional-table-formatting/
As well as if it is a matrix under the Properties and then conditional formatting you have the option for Background Color scales, Font color scales and Data bars
- AnonymousNot applicable
Thanks GilbertQ, but I couldn't find any condition formating in Matrix table. I believe we can't do any formatting using certain condition in Matrix table.
Pls correct me if I am wrong.
Thanks,
Thimma- v-sihou-msftMicrosoft Employee
Anonymous
You can click on the field to select conditional formatting.
Regards,
- v-sihou-msftMicrosoft Employee
Anonymous
Currently, we can only use conditional formatting for your requirement. But the color is diverging based on your value. It's not possible to give condition like "IF Value > 25K, Green, Red".