I have a table report in Power BI. I need to change/Set background color of a Cell based on another cell value as follows.
Eg: Row1 - Individual Cell's background color changes to green if corresponding Expected val is reached[85>70].
I found Conditional formatting in tables has this ability. I'm not able to get value of cell and make comparison to achieve color coding.
Please suggest on how to extract value of cell in Power BI to set/change background color.
Currently, PowerBI supports only column based formatting through option Conditional Formatting https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting
Row-Based formatting option is not yet available. This feature can be suggested in POWERBI IDEAS forum.
https://ideas.powerbi.com/forums/265200-power-bi-ideas
PowerBI community to connect: