Hello,
I have the following situation.
I have a vertical bar chart showing on the x-axis a “description” and on the y-axis how often this “description” ocurred. In a second vertical stacked bar chart, I show on the x-axis calender weeks, on the y-axis how many times different “descriptions” occured. The bar is grouped by the description.
I configured a filter action that the second visual only shows the “description” selected in the first visual. Is it possible to leave that filter action and additional only show the second visual if a selection was made in the first visual? I found some instructions for an example with tables but I was not able to apply it to my analysis. It would be great to get some help if possible.
Hi @Eva207,
There is a way you can accomplish this through using a parameter. While the fields are different, I’ve created an example in Quick Sight Arena:
Show bar type visual based on click in another bar type visual
Note, you will need to have your analysis setup in free-form to manage hidden visuals.
To start, you’ll want to make a parameter for your descriptions. Make sure to set the default value as text that does not match any of your description values (In my example, I just used ‘None’).
Next, instead of using the first visual to filter the second visual, setup your action to have it filter your parameter (use navigation instead of filter action for this).
Then setup your second visual to filter based on your parameter.
Last, you’ll setup a Rule on your second visual to hide based on your parameter equaling whatever you set as your default value for the parameter.
Let me know if you have any additional questions.
Thanks a lot it is working!
I am facing another issue, I could not find an answer yet.
I found out that it is possible to reset the parameter to its default manually.
My question is: It is possible to reset the parameter automatically?
E.g. if another filter which is applying to the visuals is changed manually by the user? This manual change of the filter makes the selection of the parameter invalid. In this case, I would like to set parameter to its default and hide the visual. Is there any action or something similar which would make this possible? Or if the user clicks in the first visual anywhere but to a bar, the parameter will be set to its default.
Hi @Eva207,
I’m not quite sure I understand the portion about setting a parameter to default and hiding the visual. Why would you want to hide the visual? Does each parameter control a different visual that are layered on top of each other?
You can setup an action that resets a parameter (or multiple if needed) back to it’s default value by clicking on the visual (see below) and then you can setup a rule to hide the visual based on the parameter value (which you can setup as the parameter’s default value. That way, when it resets from clicking, it should hide it as well.
Just make sure that the target sheet is the same sheet as your visuals. You can add more than one parameter to the action if you need to reset multiple.
Let me know if this could work for your case
Thank you for your answer. That is working but at the end not really what I need :(. But I found another solution :).
My intention was to only show the visual if a bar was selected in another visual. But I found out that hiding means that in the dashboard a white space is shown. That was not my intention. It would be great to also have the possibility on free form layout settings to not show the white space if a visual is hidden and there are other visuals underneath such that those are automatically moved up to fill the “white space”.
Hi @Eva207,
The function you mention above is possible within free-form layout. If you stack one visual on top of another, you just need to make sure and ‘hide’ the background on both visuals:
This will allow the other visual to show through when the first one is hidden therefore it won’t just be a blank white space. Is that what you’re looking to do?
Thank you for your answer.
But that is not really what I need. I have several visuals, I always want to show.
And then there are two visuals, I only want to show beneath another visual, if a selection was made in the above one. I don´t want to hide another visual while showing these two visuals. Due to content and talking of two visuals, I also don´t have the possibility to put it to end of the dashboard where the white space would not disturb the whole UX of the dashboard.
Until now, I only found the way you described by putting to visuals above each other. I don´t know if there exists what I was looking for.
Hi @Eva207,
Apologies, I believe I understand what you’re looking to accomplish now but as you mentioned, it’s currently not possible to have things ‘shift’ based on visibility. The real estate that holds a visual (hidden or not) will always be present.
Hi @Eva207,
Following up here as it’s been awhile since we last heard from you, did you have any additional questions regarding your post?
If we do not hear back within the next 3 business days, I’ll close out this topic.
Thank you!
Hi @Eva207,
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.
Thank you!