Conditional color formatting of one column from another column

[sajal161292]

Hi,

I have a requirement in  the report to color a column A based on the result set of another column B.

If B is negative then A should be red

else no color

Could you please provide me a way of achieving it in Power BI?

[v-jiascu-msft]

Hi @sajal161292,

There is such a new feature of the May 2018 release. Please give it a try and refer to blog/power-bi-desktop-may-2018-feature-summary/#conditionalFormatting.

Best Regards,

Dale

[v-jiascu-msft]

Hi @sajal161292,

I would suggest you vote up this idea or create a new one.

Best Regards,

Dale

[Greg_Deckler]

Off the top of my head, I can't think of a way to do that currently.

[sajal161292]

Hi @Greg_Deckler,

Is there any alternative way to achieve this in Power BI?

I see that this idea is still pending to be implemented in Power BI.

[Greg_Deckler]

Check out this blog article:

https://community.powerbi.com/t5/Community-Blog/Power-BI-Desktop-Custom-Aggregations-Formatting-and-...