in quicksight how can i use conditional formatting or something similar to hide a table visual until the entity name parameter filter is used. i have 2 table visuals i want to hide until the parameter filter is applied by the user.
Hi @izzycs ,
So to apply hide/show logic to a visual, you are going to go to the interactions tab within your properties panel and within there is a dropdown called ‘Rules’. This is where you decide when and how you hide/show your visual. Depending on your use case you can decide if you want your visual to show by default or hide by default by clicking on or off the switch.
From there, you are going to pick your parameter and then create a condition.
Depending on what you set as your default decides on how you create your logic. So, as an example, let’s say I set it so it hides the visual as default. Then within new rule menu you would pick your parameter, set it so when the parameter equals a certain value it will show the visual as the action. In order to control what value the parameter is set to will be done with a control.
One caveat is that the hide/show ability on visuals is only allowed to be done when the sheet layout is set to ‘free-form’.
Hope this helps!
Hi @izzycs ,
if you go to the analysis settings and click the sheet settings dropdown, is your sheets layout in free-form?
When I tested it out with a table visual, the rules menu would only appear if the sheet layout was in free-form.
1 Like
is it possible to hide a table visual until a drill down action is clicked ? I currently have a filter action in my main table visual but i do not want the table below to be seen until the filter action is used
Hi @izzycs ,
For future reference, once a post has been solved it is best to create a new topic with your new question and then reference this post or any other related post in your new topic.
But for this, you would create a navigation action for the visual so you can have the option to attach parameters to the action. That way when you click on it, it can assign a value to a parameter and then from there use that parameter value within your hide/show logic.
1 Like
got it will do moving forward, appreciate the quick response
1 Like