Filter on non-existent values (Custom filter)

Hi together,
I which to create a filter in publication which also preserves filtering on values which are currently not in the data, so that I get a blank output.
I tried a list but I'm not sure how I can create one which is not based on any column.

For example:

Index    Colors
1    Red
2    Blue
3    Green

Desired filteroptions:
> Red
> Blue
> Green
> Orange
> Purple

Filtering on “Red”:
1    Red

Filtering on “Orange”:
-    -

1 reply

    • Eduardo_Azanza
    • 3 yrs ago
    • Reported - view

    Hi Philipp, would you be available for a remote session? I'd like to understand what you're trying to achieve; if you're, please, let me know when and I will send over to you an appointment.



Content aside

  • Status Answered
  • 3 yrs agoLast active
  • 1Replies
  • 29Views
  • 2 Following