Hi,
I want to hide a filter based on the user who is logging in.
In the below link, the data is from 3 clients.
If I am a user from Amazon, meta or google, then I should not be seeing the client filter. If I dont have any company assigned to me, then i should be able to see the client filter. Basically hiding / unhiding filter based on the user.
Hello @liya101, if you want to hide the filter from displaying altogether, then the only way to manage this would be through the use of the free-form layout and conditional rules, with Row Level Security to ensure proper client level values are filtered out.
Using a mix of RLS, Dynamic Default Parameter values, and conditional rules, you can ensure the filter is only displayed for specific users. If you have a dataset that links your quicksight users or groups to certain clients or returns a value like Admin, that can be used to build the conditional rule.
You can hide the control by default, but if a user logs in with the Admin value for their permissions, it will display. I can provide documentation on the dynamic default value for parameters and I will link the Arena analysis where I have implemented the conditonal rules logic. Let me know if this helps!
Hiding filter
Hi @DylanM . Thank you so much for helping out.
Could I also know if there is a way to hide different sheets in a dashboard based on the user?
Hi not as of now we can’t hide sheets for different users in QS.
Hello @liya101, if you wanted to show and hide sheets based on user permissions, the best way to work-around this would be to have a few different versions of the dashboard that would be shared with various users or groups. The only way to manage the view of specific sheets would be through the embedding process and showing/hiding sheets with conditional logic in code.
If you are not embedding, publishing different dashboards would be the best route to manage this.
Tableau and PowerBI designer here trying to translate to Quick Sight.
I need a filter pane with multiple filter options to be hidden to start and then to unhide when the user clicks a filter icon.
In PowerBI, I accomplished this functionality with Bookmarks and Selections that have layer order options. I included a shape (rectangle) that was filled with a solid color that had slicers (aka filters) layered on top. I also had a hide button on the panel (rectangle) that would hide it once selections were completed.
Does Quick Sight allow the layering and grouping that would allow the panel to appear as one “unit” when the filter icon was clicked?
Appreciate any insights.
