Change caption in title text of chart based on variable values

[jack]

In chart is based on value of   key  with a value   B','K','X','I'   in dimensions 

B stands for bread orders, K stands for Kilo orders,  X stands for Frozen orders, I stands for Import orders

Would be fine if caption changes by one pick or a mix of more picks

Like this sample if 2 are  active 

[Aurelien_Martinez]

Hi,

Have you try a expression like :  Concat(distinct [Website type], ', ')

Aurélien

[jack]

Hello ,   tried that one,  just did show me  exactly  " Concat(distinct [Website type], ', ')""

even after change to real field name  Concat(distinct [Website], ', ')

Then i tried this , but that only works ok is one click is active,  thus could you suggest how to

modify it so it will  concanate alle clicks ?

below will only work with one active click

=if(IsNull(Website),'All  Products ',' Sales for: '&Website)

[Aurelien_Martinez · Accepted solution]

Have you try with the equal sign ?

Like :

 ='My title ' & Concat(distinct [Website], ', ')

[jack · Accepted solution]

That worked,  thanks a lot 

Best regards Jack