highlight values in matrix /Tabular chart

[Anonymous]

Hi All,

Need help in Highlighing the value that fall above range 60%  in Matrix or Tabular chart.

i my example i had used Matrix chart.

Regards,

Samuel

[az38]

Hi @Anonymous 

Go to the Visualization Pane, find your values field (which return you a percentage), click an arrow near the field name, select Conditional Formatting -> Font colorSelect Format by Rules, then apply your rules

do not hesitate to kudo useful posts and mark solutions as solution

[Anonymous]

Hi az38,

I had tried that option but the rule does not work.

For example i have given More than 80% but you can see even below gets highlighted and also other numbers(the overall colum gets highlighted)

Regards,

Samuel

[az38]

@Anonymous 

it shouldnt be a count function. try another aggregation like sum or min/max or average. it depends on your data model

do not hesitate to kudo useful posts and mark solutions as solution
Linkedin