Forum Discussion
Solved
Creating a measure that using slicer value as variable ignoring any filter context
Hi! I need to create a measure that will return selected value in a slicer ignoring any filter context. In other words I need these dates highlighted in yellow (img below) to be 2019 as selected...
Hi anonymous3
Try with a separate/disconnected table that contains one column containing the three years.
tamerj1
Community Champion
Community ChampionLet get that straight.
in the original example, the measure _SelectedYear is based on the column StartDate and both are used in the table visual. Yet, when you select a StartYear from the slicer, the table is not filtered. That means you've cancelled the interaction between the the slicer and the table visual. Is that correct?
Sorry, I indeed canceled the interaction. Thank you