Hello Everyone,
I have 9 visuals in my quicksights sheet, and I want to show only one charts at a time to the user.
I want to add a dropdown or buttons with each visual name on the buttons.
If user selects a button then that visual should be visible to the user and all the other visuals should be invisible.
How can I achieve this?
Hi @nishchay0001,
You can do this by using free-form layout and parameters. In free-form layout, stack all 9 visuals and hide them by default.
Create a text parameter and use it to add a control. The control should be a dropdown list of all the visual names.
Then, add a rule based on the parameter having a value equal to the name of the visual you want to show.
Hi David,
I am not getting this rule option in the pivot table. Can you please check this?
Hi @nishchay0001,
Can you please confirm if you’re using the free-form layout? When you format your visual, you should see an Interactions tab which contains the option to hide the visual by default.
If you don’t see it, can you share a screenshot showing what you see?
Hello @David_Wong ,
Thanks I am getting this option. I was seeing the actions tab at that time.
Can you please help me setting up a parameter and adding a control for this?
Create a string parameter (single value). The static default value should be the name of the visual that you want displayed by default.
Add a control as a dropdown list for your parameter.
Enter the name of all your visuals as the specific values that you want displayed in the dropdown list.
In free-form layout, format each visual by enabling the “Hide this visual by default option” and add a rule to show the visual when the parameter value is equal to the visual name.
Finally, stack all your visuals.
When a reader selects a visual name in the dropdown list, the corresponding visual will be displayed and all the other ones will be hidden.
Hello @David_Wong ,
I have done these steps and this is working fine.
But one problem which I am facing is that, Suppose I clicked on one of the value in the dropdown then the other is getting disappeared in the dropdown.
As you can see in the above image, I have 2 values in the dropdown.
Currently CurrentMonth is chosen by default.
Now, If I click on monthOnMonth to show the second visual then CurrentMonth is disappeared from the dropdown.
Kindly help in this.
Hi @nishchay0001,
Can you show a screenshot of how you created the parameter and control?
Hello @David_Wong ,
I made a mistake while creating the parameter and control.
I read your steps and recreated them .
Thanks for your help.
