how to get font colors of a column based on other column values in powerbi desktop

[Anonymous]

Spoiler

hi all,

i have a requirement to change the colour of a column value to red if all other column values in the row are blank if not in blue..
eg:
 

 

  in above eg, cost has value and investment,interest column has no value in first row ..then cost should show in red font ,rest all cases.. everything should be in blue. how can i acheive this..i think with conditional formatting itelf i can't acheive..although i tried..but no success..
can any one please give an idea of this how can i format or give the font colors based on above functionality..
thanx in advance..

[v-yulgu-msft · Accepted solution]

Hi @Anonymous,

Unfortunately, it is not available to set font color conditionally based on values of other column. Here are two similar ideas, you can click to vote it up.

Conditional cell formatting based on the value of ANOTHER cell.

Conditional Formatting with fixed colors not color scale.

Best Regards,
Yuliana Gu

[Anonymous]

thanx Yuliana Gu for the reply. i have shared my views in links provided..