One dashboard with same visuals pulling from different datasets

[GaBon]

Hi all,

I have a dashboard with various visuals that currently pull data from datasource A only. I want to add another datasource, B, and a dropdown control that allows users to choose which dataset the visuals pull data from—either A or B.

Both A and B are created via direct query and this is something we do not want to change.

So far, I have:

• Added the B dataset via Data > Add dataset
• Created a parameter called $DatasetSelector with multiple values (A or B)
• Added a dropdown control

How can I ensure that the data is dynamically pulled from the selected datasource without changing the type of visuals? In other words, I want the dashboard to look the same, with the only difference being the dataset used.

Thanks!

[Giridhar.Prabhu]

Hi @GaBon

You may have noticed that when you create visuals in QuickSight it is based on a dataset. The dataset selection is not dynamic.

1. That means you may have to create the same visuals using your Dataset B as well.
2. Change your Sheet type as Free Form which enables you to show/hide visuals based on a parameter
3. Use the steps outlined in the post below to use your parameter to show the visuals either based on Dataset A or Dataset B

Hiding visuals on free form

hey, guys. I’m trying to use free form layout to creaate a filter with 5 options, when i select an option displays related visuals while hiding the rest. However, the only way i’ve found to make this work is by stacking the visuals on top of each other. Is there a way to make a visual disappear and have the subsequent visuals move up to a specific point? It seems challenging to edit if I have to stack all 5 groups of visuals on top of each other.

[GaBon]

Thanks! Just tried with one visual only and it works