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

excel powerbi powerbi-embedded powerbi-desktop
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/

Related questions

Using Multiple filters in DAX

I'm new to DAX. I'm currently using Power BI and trying to create a total sum of sales that use a few different SKUs (or IDs) I can use this to filter down to 1 sku ("A1"): Measure = CALCULATE([Sum of …

Read More
Power BI (DAX): Distinct Count Filtered by Condition

I have a data set with publishers with revenue by month. Publishers are considered to be "active" month if their revenue is equal or greater than 1000 for a given month. Now, I want to count the distinct number of "active" …

Read More
How to specify an API key name in Excel - A web API key can only be specified when a web API key name is provided

I have a standard MVC API OData enabled service which works under anonymous authentication. I would like to pass a web API key to the application...which works fine when added through code or postman.. Unfortunately my users would prefer …

Read More