How can I apply two filters in my analysis where one acts as a user filter and the other is fixed? I want the user to control one filter while the other remains static with a specific value. I understand that using the “change relevant value” option in control options won’t work in this case.
For example:
- Filter A: User can select different values available in dropdown.
- Filter B: Fixed to a specific value (e.g., Region = “North America”) and should not be changeable by the user. (not available to user in analysis).
I want Filter A to have a relevant dependency on Filter B, but Filter B will not be available as an option to set this dependency as it is not present/showed in analysis.
How can I achieve this setup?
Hello @nitesh1890,
Welcome to the QuickSight Community, it is great having you here!
If what you want is to control what data is shown to a specific user and that “filter” cannot be changed by the user, then I think you could use RLS.
Hope this helps!
Hi @andres007,
Thanks for your response 
Actually my question was while we work on analysis (creation of dashboard).
It would be great if we could show relevant values based on any filter without the requirement for the filter to be in a control. Currently we can only show relevant values based on the selection in another control. If I have a filter that doesn’t have a control, I cannot have relevant values based on it.
Sometimes we apply a filter to a dashboard but we don’t want to expose that filter in a control so that users cannot change it. Because we can’t have relevant values based based on that filter, users see irrelevant values in other controls. If this is not possible, do you know any possible method where we can work.
Regards,
Nitesh
Hi @nitesh1890, I’m out of ideas. Sorry, currently this is not possible but I’m marking this for feature request. At AWS, their roadmap is primarily driven by customers. Your feedback helps them build a better service. I have tagged this as a feature request. More features are being added on a regular basis, so please keep an eye on the What’s New / Blog . You can set up a Watching Alert by clicking on the bell icon.
You could look to opening up a case with AWS and see if they can provide a solution.
Here are the steps to open a support case . If your company has someone who manages your AWS account, you might not have direct access to AWS Support and will need to raise an internal ticket to your IT team or whomever manages your AWS account. They should be able to open an AWS Support case on your behalf. Hope this helps!
1 Like