Hello, I need to create a toggle switch that change the data source.
I have a dashboard on tableau with data from A, and i want a toggle to switch to data from B. Data sources A et B are the same construction but with different datas.
Is it possible ? Thanks guys
Hi @Kévin HEUGAS ,
you can give a try to this approach hope it will work or if you need any further assistance let me know on this .
· Set Up Parameters: Create a parameter to act as the toggle switch. This parameter will have two options: one for Data Source A and another for Data Source B. Choose the data type as string or integer.
· Create Calculated Fields: Create calculated fields that will act as indicators for the selected data source. For example, you could create a calculated field named "Selected Data Source" with a formula like:
IF [Parameter] = "Data Source A" THEN [Field from Data Source A] ELSE [Field from Data Source B] END
· Use Calculated Fields in Visualizations: Replace the original fields in your visualizations with the calculated fields you created in step 2. This will ensure that the data displayed on your dashboard updates based on the selected data source.
Please, don't forget to click Select as Best or Upvote
Thanks !!
Please, don't forget to click Select as Best or Upvote !
Thanks!!
Payal
