Conditional Formatting in Matrix Table

[nagaraj007]

Hello All,

I have a scenario wherein I am using Table matrix and want to show conditional formatting if the show 2 numbers are greater than show 1 then show GREEN, if the show 3 data is lesser than show 2 data then show RED. Below is the sample table.

Please advice how to go about this.

Company Name	Show 1	Show 2	Show 3
ABC	20	30	10
xyz	10	20	30

[Icey]

Hi @nagaraj007 ,

You can try this:

1. Create measures.

Condition1 = IF(MAX('Table (2)'[Show 2])>MAX('Table (2)'[Show 1]),1,0)

Condition2 = IF(MAX('Table (2)'[Show 3])>MAX('Table (2)'[Show 2]),1,0)

2. Conditional Format.

Then, the Matrix shows like what you want.

Best Regards,

Icey

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

[nagaraj007]

Hi Icey,

I am unable to get the required solution as per the below query. I have a table as per mentioned below

ExhibitionName    -----------------Table Name

Form2016---------------------------Show Name

Form2018---------------------------Show Name

Form2020---------------------------Show Name

Please advice.

[Icey]

Hi @nagaraj007 ,

Maybe you can give me a screenshot. 

Best Regards,

Icey

[nagaraj007]

[Icey · Accepted solution]

Hi @nagaraj007 ,

Do you mean that "From 2016", "From 2018", and "From 2020" are measures?

If so, you can create the two measures like so:

Condition11 = IF ( [Measure 2] > [Measure], 1, 0 )

Condition22 = IF ( [Measure 3] > [Measure 2], 1, 0 )

Best Regards,
Icey

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

[nagaraj007]

Thank you very much for the help.