Based on other value format color of another value in matrix table

[harshadsp]

Hello,

Need your help. Is there any way I could format red color of one column based on some value in another column?

For exmaple:- If the value in Diff column is <0 then colour the corresponding value in Y column as red.

I tried making one column as below and then rename this to Y but the problem is that the value in Y column comes as negative with this and then I use conditional formatting in BI desktop to colur as red but I really do not want to show actual value as negative.

if(Query1[Diff] < 0,Query1[Y]*-1,Query1[Y])

I need to color value of column Y based on value of column Diff.

Please advise.

Thanks!

Harshad

[v-yulgu-msft]

Hi @harshadsp,

Unfortunately, this is not supported by Power BI now. The current conditional format only supports color scale based on current column values.

Here are some ideas, you can click to vote it up.

Conditional color of one column depending on another column

Conditional Formatting with fixed colors not color scale.

Best regards,
Yuliana Gu

[harshadsp]

Thanks @v-yulgu-msft for confirmation on this.