So, I have one report and 4 roles to select from the dropdown, data will get filtered for that particular role, but there are few columns as well which we only need to display for a particular role, Can someone pls suggest if we can hide column based on user selection
Hi @bhumika18s,
Thank you for posting.
Amazon Quick Sight does not currently support dynamic hiding or showing of specific table columns based on parameters or filter controls in a standard table visual.
You can use free-form layout mode to overlap multiple visuals (One per role/column layout), create parameter for role selection and use conditional display rules to show/hide the appropriate table visual based on the user’s dropdown selection and finally, for table visuals, blank out values using calculated fields if certain columns should not be populated for a selected role.
Kind regards,
Demola