Forum Discussion
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 value of StartYear slicer is 2019. I need _SelectedYear measure be equal to selected value of slicer in any filter context.
I desperately need your help. Please, save my weekends.
Hi anonymous3
Try with a separate/disconnected table that contains one column containing the three years.
4 Replies
- tamerj1
Community Champion
Hi anonymous3
Try with a separate/disconnected table that contains one column containing the three years.
- tamerj1
Let 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
