Forum Discussion

bo_afk's avatar
bo_afk
Post Patron
7 years ago
Solved

Apply filter onto a filter visual

 

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

Need Help
  • parry2k's avatar
    parry2k
    7 years ago

    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

1 Reply

  • parry2k's avatar
    parry2k
    Super User
    7 years ago

    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