- Newest
- Most votes
- Most comments
This issue you're experiencing with Amazon QuickSight where the filter doesn't show all values from your dataset is a known limitation in some cases. Here are a few things to consider and try:
-
Data source quotas: Make sure your data doesn't exceed QuickSight's data source quotas. Sometimes, if the data exceeds certain limits, it can cause unexpected behavior in filters and visualizations.
-
Data compatibility: Ensure that your data is compatible with QuickSight's supported data types and values. Incompatible data can lead to issues with filters and data display.
-
Calculated fields: If you're using any calculated fields in your dataset, verify that they're working correctly and not excluding any data unintentionally.
-
Refresh schedule: Check if you have a refresh schedule set up for your dataset. If not, you may want to set one up to ensure your data is updated regularly.
-
Manual refresh: Try refreshing the dataset manually to see if it resolves the issue. Sometimes, a manual refresh can update the data and fix filter problems.
-
Cross-sheet filters: If you need the filter to apply across multiple sheets, consider using a parameter-based filter instead. Create a parameter for the customer name, add a control for it, and then create a filter using this parameter. Set the filter scope to "Cross Sheet" to apply it across multiple sheets in your analysis.
-
Browser cache: Clear your browser cache and cookies, then try accessing the dashboard again. Sometimes, cached data can interfere with proper data loading and filtering.
If none of these solutions work, you may need to contact AWS Support for further assistance. They can help identify if there's an issue with your QuickSight account or if there's a known bug affecting your specific use case.
Sources
Troubleshooting skipped row errors - Amazon QuickSight
Quicksight Dashboard - Data not refreshing on time | AWS re:Post
Quicksight - filter for all sheets | AWS re:Post
QUICKSIGHT DASHBOARD LOGIN ISSUE | AWS re:Post
Relevant content
- asked a year ago
- AWS OFFICIALUpdated 9 months ago