Matrix heat chart: have different targets for each column.

[Anonymous]

Hi all.

Is there a way to have different targets for each column in a matrix heat chart?

i.e. department A has a target of 100 and so the value of 98 should be darker;

dept B should only get darker nearer 300 instead.

I can only seem to have a target for the whole matrix.

Or is there a better chart to compare these values?

Many thanks for looking.

[amitchandak · Accepted solution]

@Anonymous , Based on what I got you have to create a measure like that and have diff with value and use that in conditional formatting

Switch( True() ,

max(Table[Department]) = "A" , 100 - [measure],

max(Table[Department]) = "B" , 300 - [measure],

200 - [measure]

)

use this for conditional formatting

[Anonymous]

That's perfect! Thanks a lot