topic Re: Conditional Formatting for a field in Column based on it's value in Matrix Visual in DAX Commands and Tips

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

PS_78 — Thu, 20 Jun 2024 16:16:47 GMT

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

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

Anonymous — Fri, 21 Jun 2024 02:01:48 GMT

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.

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

PS_78 — Fri, 21 Jun 2024 14:39:32 GMT

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

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

Anonymous — Wed, 26 Jun 2024 07:23:42 GMT

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.