Hi Experts, I have dashboard that has more than 6 visuals and each visual have “Select“ with “Filter“ Action enabled. When user selects a value in Chart 1 all the other visuals gets updated with the value. With the cascading filter it becomes very difficult for the users to know what value they have selected. Only option for now is to select the “Applied Filters“ section which is not a great user experience.
Is there a way to display the value that is there in the Applied filters. I tried options but none of them seems to go with my requirements.
Parameters can be used to display but I believe I can use the paramater to display the selected value only if it is in the Controls.
The only way to display selected values would be through the usage of parameters like you mentioned.
Parameters essentially act as value placeholders; so if you set a navigation action to assign a value to a parameter, you don’t necessarily need a control present. The parameter value can be set based on the navigation even if you do not have a control for it on your analysis, it will just be more difficult to reset. Which in that case, you could design a make shift button to reset your parameter values so that the visuals return back to normal…let me know if you’d like additional information on how to create a button).
So what I would suggest; instead of using a ‘filter’ action, setup as a ‘navigation’ action (but keep it so that it ‘navigates’ to the same sheet as all your visuals.
Using a navigation action allows you to assign a value in the parameter control based on your visual selection.
So as you can see in the visual, selecting ‘communications’ sets my second visual to only show my selected value, and it assigns that value in the control. If you don’t want to give your users the flexibility of utilizing the parameter control, you can also remove the control and the filtering will still take place.
Let me know if this helps with your case or if you have any additional questions!
Hi @Brett Thank you for your response. I too kind of did the same. Created an Action with Action Type as “Navigation“ as you mentioned and captured the value in the parameter and further used that Parameter value to filter other visual. In this case the Reset is not happening and users requested for reset option.
It would be of great help if you can share the steps to design a reset button that can be used to reset the Parameter.
I’ve put together a sample analysis where I created various types of buttons for different use cases; which you can check out through Quick Sight Arena: Creating and Utilizing Buttons
One thing to mention regarding this; I used free-form layout as it gives you more flexibility of hiding visual backgrounds, etc.
You’ll start by creating a calculated field that simply says what you’d like your button to show in the text, for instance I used ‘Reset’:
As you can see in my example above, I have the ‘Region’ parameter’s default value set to ‘AMER’ and all the other parameters set to ‘All’ so I match my action to those values.
Since we have not heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new post in the community.
