Matrix table with conditional formatting

[Anonymous]

Hi all,

I have a question. Below is a screenshot of my dummy data and final output that I want to achieve.

This data is about Average Population for ach Country. 

Population by Age Range:

Final Output:

Note: Row 5 is the Average Population for each Country

I want to allow the data cell to change color based on the Average Population for each Country. 

If it is lower, Green. If it is higher, Red. 

As you can see that D2 is green because it is lower than the average (1.35).

My question is how should I come out with the logic so that the cell will change color for Matrix table.

Thanks and Regards!

[v-yulgu-msft]

Hi @Anonymous,

Unfortunately, this is not supported yet in current release desktop. Here are two similar ideas, you could click to vote it up:

Conditional formatting between two measure

conditional formatting intervals

Regards,

Yuliana Gu