Hello
I have added a filter to one of the visuals and added to the sheet - But the dropdown is not showing any value in the dropdown. Is it something like, quicksight has any limit to display the values in the dropdown or is there any other reason. Could you please help me with this?
Hi @shravya,
I did encounter this scenario, where, if the unique count of values for the field (on which we are filtering, in your case ‘Agency’) is greater than 1000, then the respective values in the dropdown are not being displayed.
However, we can search for the value in the ‘search value’ box and get relevant matches and then checkbox the one you wish to filter for.
I hope this helps.
Thank you
Thank you @muneersyed - But I do have same filter for the other report and I was able to see the values. Yeah i am aware of searching in the search box but specifically i am looking for the dropdown.
Thank you for your time.
I did find an alternative solution to this - Like, as I have more than 1000 values in my dropdown list - It was storing 2 types of Agency details so I split that up into two variables so that I can see the values in the dropdown and that’s working.
Thank you @muneersyed for your time. I appreciate that.