Forum Discussion

PS_78's avatar
PS_78
Icon for Helper II rankHelper II
2 years ago
Solved

Conditional Formatting for a field in Column based on it's value in Matrix Visual

Hello Team - I have a matrix visual in my report with "Year and Period" on Rows, "Close Days" in Columns and "Count" on Values. I would like to do a background color for a column based on "Close Days...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi PS_78 ,

    I create a table as you mentioned.

    Then I use the matrix visual.

    I think you can create a measure and here is the DAX code.

    Measure = IF(MAX('Table'[Number])>43,"Red",BLANK())

    Then you can use Conditional formatting.

    Finally you can get the Background color. While Power BI does not directly support adding lines within a matrix to differentiate values.

     

     

     

    Best Regards

    Yilong Zhou

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

PS_78's avatar
PS_78
Icon for Helper II rankHelper II
2 years ago

Hello Anonymous - Thanks for your quick help. I was overthinking that I should do conditional formatting on "Columns". I tried this and it did work like a charm. However, I would like to color the complete column where Number > 43 irrespective of whether it has values or not. Is it possible?

Thanks,

Phani

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi PS_78 ,

If there are values in the table, and if they are 0, it can achieve the whole column in the red color you need.

However, in the case of a displayed Blank, there is currently no function to display the blank value in the matrix as the same color for the entire column.

 

 

 

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.