Switch Charts using one Variable set in Button

[ivandrago]

Hi,

I have the attached Document, I need help with the formula that is in on the Button, I want it to loop around the three available charts, which are Dimensions, Measures, Filters. I had this work when it was just two charts but unsure how to get this to loop around when I have three charts?

Any Ideas?

Thanks

[sunny_talwar · Accepted solution]

Check attached

=if(vSwitch=1, 2, If(vSwitch=2, 3, 1))

[Anil_Babu_Samineni]

Correction based on text to Chart Titles. Text object should be this..

=' Show '  &if(vSwitch = 3, 'Filters',if(vSwitch = 1, 'Dimensions',if(vSwitch = 2,'Measures')))

[sunny_talwar]

Thanks Anil!! I didn't even look at that as I was too much engrossed in getting the variable working

[ivandrago]

Thanks Anil, actually what Sunny has done is what I want, as I want it to say Show Measures if the current Chart that is open is on Dimensons