How to change/Set Background color of a cell [Row-based] in Power BI

Shalem picture Shalem · May 9, 2018 · Viewed 7.3k times · Source

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.

enter image description here

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.

Answer

Aditya Prasad picture Aditya Prasad · May 23, 2018

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:

https://community.powerbi.com/