Filter control selects all values when empty

Question & Answer
, ,
1

I currently have a filtering issue when creating a control with the “Text field - multiline” option:

  • If I delete all values of the filters, the connected graphs and tables then *select all
    possible values    .

  • Instead, what I need to happen is for the graphs and tables to show “No Data”.

You can see an example in this adaptation I’ve made of DemoCentral’s “Viewership Insights” (From the Media Entertainment Viewership Analysis)

As you can see, even if the “Age Segment” filter (top right) is empty, the graphs show all the data. Instead, I need the graphs to display “No data”

AWS QS filter demo
AWS QS filter demo1365×474 71.2 KB

This does not seem to happen with other options of filter control, such as dropdowns (shown in the “year” filter)… but I need a multiline control, and I need it to default to “select none” when it’s empty.

What am I missing?

2

Hi @JesusDeSivar and welcome to the QuickSight community!

You can accomplish this by using a parameter control. Start by setting up a parameter for age and under ‘static multiple values’, write in ‘None’ or however you’d like it to appear.

image
image594×702 24.4 KB

Once you create, you’ll then be prompted to add the parameter, choose ‘control’ where you can setup as a Text field - multiline.

Last, setup a filter on each visual. Choose a ‘custom filter’ and link it to the parameter you just made.

image
image1327×631 72.1 KB

Let me know if this works for your case or if you have any additional questions!

3

Hi @JesusDeSivar,
It’s been awhile since we last heard from you so following up to see if you had any additional questions?

If we do not hear back within the next 3 business days, I’ll go ahead and close out this topic.

Thank you!

4

Hi @JesusDeSivar,
Since we haven’t heard back, I’ll close out this topic. However, if you have any additional questions, feel free to create a new post in the community and link this discussion for relevant information if needed.

Thank you!