I have a dropdown multiselect control in an analysis that gets the data from a dataset.
This control lists the account names. All the accounts are shown by default. As they are hundreds, they are not listed, but the user needs to search for it by typing it.
Is there a way for the user to filter out (i.e., exclude) one specific account?
For example, I have Account 1, Account 2, Account 3, …, Account 100. As “All” is selected by default, the chart shows data for the 100 accounts. As a user, I’d like to show data for all the accounts except for Account 50. So I’d like to search for this account and untick it so the chart shows data for the rest of the accounts.
If the list of accounts were short, it would be OK. But as there are many accounts, I don’t find a way to do this, both with dropdown or list controls.
I’m guessing you also don’t want “Account 50” to be searchable in the filter. You can do this by creating 2 filters for this field and using free-form layout. Add the first filter to the sheet and hide it in free-form layout (or move it behind a visual so it’s not visible). In your first filter, exclude “Account 50”. Add your second filter to the sheet or as a control and make it show relevant values based on the first one. “Account 50” won’t be displayed in the second filter and also won’t be searchable.
“Account 50” should be searchable. Some users may want to see data for this specific account, or for all, and some others may want to exclude it (this account as an example or some other account).
I’m thinking like something as a filter in Excel, where all the elements are including by default by I can de-select a specific one:
If you want it to be searchable, then it’s more straightforward. You just have to unselect the value in the filter in your analysis before you publish your dashboard. By default, readers will see it unselected but they will be able to select it if they want.
All the items in the list need to be selected by default, so that the chart shows data for all the accounts.
Then a user may want to filter for one specific account or a few of them. This is OK.
However, they may want to show data for all the accounts excluding one or two. As there are hundreds of accounts, I don’t see a way to search for a specific account and deselecting it, so the chart shows data for the rest of the accounts.
OK, I understand what you mean now. The only workaround I can think of is to create two filters - one for the items to include and the other for items to exclude like this:
