Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

highlight values in matrix /Tabular chart

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
Tips and Tricks
az38's avatar
az38
Icon for Community Champion rankCommunity Champion
6 years ago

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's avatar
Anonymous
Not applicable
6 years ago

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's avatar
    az38
    Icon for Community Champion rankCommunity Champion
    6 years ago

    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