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

[PS_78]

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

[v-yilong-msft · Accepted solution]

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]

Hello @v-yilong-msft - 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

[v-yilong-msft]

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.