Forum Discussion
bo_afk
Post Patron
Post PatronApply 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...
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
parry2k
Super User
Super Userbo_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