I have created an Report. I have used a Table visual to display some of the columns like tenant, account etc, I have used filters like account, tenant, project, date and gave show relevant values only. Now, when I select 1 tenant from tenant and 1 account from account, it is showing relevant data in the filter as well in the table visual, but at the same time when uncheck this selected value from both the selected filter, all filters value disappears, and Table shows No Data. until I select reset in the filter, the values are in not there. please help me with this issue. TIA
Hi @Nazhur
Welcome to the QuickSight community!
It’s default behavior you’re experiencing, when unselecting filter values causes all filter options and table data to disappear until a reset is performed, is related to the “Show Relevant Values Only” setting. This setting can lead to situations where, upon deselecting certain filters, no data matches the remaining filter criteria, resulting in empty visuals and filter options.
Can you please, make sure that the filters have appropriate default settings. Sometimes, the issue arises if the default behavior for the filters is not specified, making them appear empty once you unselect the specific values.
You can set default values for filters so that when you clear all filters, they still show a default selection and don’t appear empty.
Consider using “All” as a default selection in the filters, which ensures that clearing specific selections reverts to displaying all the data rather than having an empty filter. Alternatively, you can create a control that allows you to reset all filters to a pre-defined state, avoiding situations where the filters end up in an empty state.
You might also want to reduce filter dependencies. If you have multiple filters interdependent with “Show Relevant Values Only,” it can lead to cascading effects where unchecking one makes others irrelevant. Consider removing interdependencies for some of the filters to avoid this issue.
Please refer to the below documentation this might be helpful for you.
Thanks for your response, I followed your solution by keeping default value as “ALL” but this doesn’t work as when new values are added to the data, it will not dynamically update. My quicksight analysis is embedded into our company’s software tool, so default reset filter is not working. So, is there any other workaround for this issue. Like creating a reset Filter button or keeping a parameter as resetFilter, if so, please let me know with demo steps to how to create using parameter.
Hi @Nazhur
Here are the steps along with screenshots:
Create a New Parameter for Reset Filter:
- Navigate to your analysis.
- Go to the “Parameters” pane.
- Click “Create a parameter.”
- Provide a name, for example, pCategory.
- Set the parameter type to “String.”
- Set the “Default value” to
All. - Click “Add control.”
- Edit the parameter control.
- In the Control options tab, select “List” and “Link it to a dataset field” option. Then select the dataset and the respective field.
Create a Filter Based on the Parameter:
- Go to the “Filter” pane in your analysis.
- Click “Add filter.”
- Select the desired field that you wish to filter dynamically, for example, Category.
- Change the filter type to “Custom filter” and the filter condition to “Contains.”
- Check the
Use parameterscheckbox, then select the parameter and apply it.
Publish the dashboard and then in the dashboard add the parameter with default value.
Example:
https://us-east-2.quicksight.aws.amazon.com/sn/dashboards/abc123-abc1-abc2-abc3-abcdefef1234#p.pcategory = All
Please refer to the below documentation this might be helpful for you.
Thank you @Xclipse , for your response. I tried the steps provided by you and it works fine.
Thank you again.
1 Like