Toggle between two charts using one button

[VickyS]

Hi Everyone,

I have two table charts. One shows values and other shows percentage.

I want to create one button which can allow me to toggle between these two tables.

Eg: If the name of button is values, when user clicks it should show all data in values, and when it is percentage, then it should show all data in percentage.

Request everyone to please help.

[Rockstar7]

@VickyS  you can add two tables to a container, create a variable and add those variable in the show condition to toggle between the charts.

[VickyS]

---

@Rockstar7 wrote:

@VickyS  you can add two tables to a container, create a variable and add those variable in the show condition to toggle between the charts.

---

Hi Rockstar,

Thank you for your response, but it seems the solution is not working.

Can you give example with screenshot, might it help.

I have already added two tables in container and linked them with variable. This is something that I did before raising this question, the issue is that i want the tables to be switched only by one button. 

For eg: if user clicks on button named Values then, value table showed show.

Once the table is displayed then name of button should change to percentage for the user to click for percentage values.

I think the solution is quite straightforward but i am lost in a way.

Please help.

[Rockstar7 · Accepted solution]

@VickyS take a button and add an action like below

and write button label below expression

=if(vShow=1,'Values','Percentage')

Now write show conditions to the tables of the container

[VickyS]

Hi Rockstar,

Thanks a lot, this works perfectly fine. Thank you very much.

Much appreciated.

Regards,

Vicky