Forum Discussion

sjain6's avatar
sjain6
Frequent Visitor
9 years ago

conditional formatting in matrix based on a different text field

Hi All, I have a measure that converts text values -completed/ in-progress/ expired- which are stored in a field, to nummbers- 0 or 1. I am then using this measure to create a matrix in PowerBI. I w...
Need Help
v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
9 years ago

Hi sjain6,

 

According to my understanding, you want the matrix to highlight some specific cells based on one column value, right? Unfortunately, this is not supported now. The conditional formatting option provides a color scale, that paints the cell with gradient.

 

In your scenario, if the matrix only contains two values, 0 and 1, to highlight the cell which has value 0, you can configure conditional formatting like below:

Reference: Conditional formatting based on dynamic values

 

Best regards,
Yuliana Gu

sjain6's avatar
sjain6
Frequent Visitor
9 years ago

v-yulgu-msft thanks for the response.

I tried this but the problem is that this way all the 0s in the matrix get highlighted. I need to highlight some specific 0s (which are determined based on the logic in another field)

 

Regards,

SJ

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee
    9 years ago

    Hi sjain6,

     

    Currently, it is not supported to highlight some specific cells conditionally.

     

    Regards,
    Yuliana Gu