Hey Guys, I am receiving this error while I am creating filter.
This field has too many distinct values. Search for a value below.
Is there any solution for this…
This is not an error, but a notification. Normally QuickSight will show all values in a list, but if there are more than 1,000 distinct values it will instead show a search box. If you add this filter to a dashboard or pin it, it will also give users a search box.
I have a similar case. By default, the filter is showing “Include - none”, so when I link it to my table, all data will be filtered out. but this is not what I want to achieve and I can’t make it select all values in the filter. any idea what the issue is?
OK, I have discovered that If I recreate the same filter and link it to my visual WITHOUT clicking on “Appy filter” it seems to work just fine. If I recreate the filter and then click on “Apply Filter” I get this stage behavior.
2 Likes