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" value. If "Close Days" is greater than D5, I would like to color it with a different color. Also I would like to differentiate the values before D6 and after D5 with a line as shown in below screen shot. Please let me know if it's possible.

 

 

Thanks,

Phani

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.

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    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.