Forum Discussion

mikmokmuk's avatar
mikmokmuk
Regular Visitor
8 years ago
Solved

Selected Values in Slicer

Hi guys,   we are trying to get the values selected in a given slicer. Idealy, we would like to return it as a text format. For instance, we have a slicer with the values:   A [  ] B [X] C [X] ...
Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    8 years ago

    Hi Mik,

     

    It should be a measure rather than a calculated column. Please try it. The calculated column won't respond to the slicer for now.

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

    Best Regards,

    Dale

v-jiascu-msft's avatar
v-jiascu-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi mikmokmuk,

 

Please try the formula below.

//if there isn't any selection, this formula will return all the values. So ISFILTERD is here.
SelectedInSlicer =
IF (
    ISFILTERED ( DimProduct[ColorName] ),
    CONCATENATEX ( VALUES ( DimProduct[ColorName] ), [ColorName], "-" )
)

Selected_Values_in_Slicer

 

Best Regards,

Dale

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    8 years ago

    Hi Mik,

     

    It should be a measure rather than a calculated column. Please try it. The calculated column won't respond to the slicer for now.

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

    Best Regards,

    Dale

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        I successfully created a measure that returns the value selected in the slicer - thank you! but now, I'd like to use this measure to calculate a column with the expression "If ('Table'[Year} <= ValueSelectedInSlicer, "Reached Phase","Did Not Reach Phase") for all rows. But someone mentioned this earlier, that we cannot use the measure that returns the value selected in the slicer in a column. Is there an alternative way to execute what I'm describing?