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

3 Replies

  • 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