Apply filter onto a filter visual

[bo_afk]

Hi,

Is it possible to apply a filter to a filter visual?

I would like to have a filter for markets for example, but only to have a few markets avaialble in the filter selection.

Thanks

afk

[parry2k · Accepted solution]

@bo_afk add another column in your model and filter on that column for the market you want to show.

For example, add new column like this

Filter Market = IF( Table[Column] In {"Market A", "Market C"}, 1, 0 )

now put this Filter Market column as page level or report level filter and filter for value 1. Your market filter will now show only few markets based on your "filter maket" column