Forum Discussion

jmarcrum's avatar
jmarcrum
Helper II
6 years ago
Solved

Use Measure as Slicer

Hi everyone -   I am trying to use the text values from a measure in a slicer on my table visual.  I created a separate table called "Category" that holds the possible text values from the measure ...
Need Help
  • v-lid-msft's avatar
    v-lid-msft
    6 years ago

    Hi jmarcrum ,

     

    We can change the measure as following to meet your requirement:

     

    Category Selection =
IF ( [Category Measure] IN DISTINCT ( Category[Value] ), 1, 0 )

     


    Best regards,

     

Greg_Deckler's avatar
Greg_Deckler
Community Champion
6 years ago

So many times you can do something like:

 

VAR __Selections = 'Slicer'[Categories]

 

Then you can do a filter like:

 

FILTER('Table',[Column] IN __Selections)

Anonymous's avatar
Anonymous
Not applicable
5 years ago

@Greg_Deckler could you give a more specific explanation? tnahk you!