7 Replies Latest reply: Jul 22, 2016 2:13 PM by Marcello Giacomel RSS

    Text Format, Color in Dimension of Chart

    Mohamed Bouhaja

      Hey,

       

      I want to personalize the Text Format in the Dimension of a  chart under a condition:

       

      If a element in the Dimension contain the word '(not active)' then I want to have this text with the function (strikethrough): ABCD (not active). In the same time I want to have this element with another Text Color.

       

      I have already tried a few solutions but it doesn't work:

       

      Dimensions ---> Text Format ---> Edit Expression:        =if([Dimension Noun]='XYZ (not active)', chr(822) & 'XYZ (not active)' & chr(822), 'XYZ (not active)')

      Dimensions ---> Text Color ---> Edit Expression:       =if([Dimension Noun]='XYZ (not active)', RGB(195,195,195), RGB(0,0,0))

       

      Thanks in advance