Changing Label of Dimension in Chart

[AdrianS1]

Hi Guys I Have a combo chart like this(dimenesion - Period1):

Can I switch for example 'WTD' in Dimension for 'WTD - 58,5% ( its my 'measure')?

I Tried expression like this but its dont work 

=if(Period1='WTD','WTD'&'-'& 'measure',Period1) but it isnt working 😞 

Any Ideas?

[brunobertels · Accepted solution]

Hi 

may be this 

Aggr(

if(Period1='WTD', Period1&'-'& 'measureForWtd' ,

if(Period1='MTD', Period1&'-'& 'measureForMTD' ,

if(Period1='YTD', Period1&'-'& 'measureForYTD' )))

,Period1

)