Forum Discussion

bobsel's avatar
bobsel
Helper I
8 years ago
Solved

Dynamic Title based on HierarchySlicer value

Is there a default/easy way to show the values chosen in a HierarchySlicer?    
Need Help
  • v-yuta-msft's avatar
    v-yuta-msft
    8 years ago

    Hi bobsel,

     

    To show a single value you selected in a slicer, you can use selectedvalue() function.

    In addition, if you select multiple values in a slicer, you create a measure to achieve selected values using DAX below:

    Measure = CONCATENATEX(ALLSELECTED(Table1), Table1[Date], ",")

     

    Regards,

    Jimmy Tao

v-yuta-msft's avatar
v-yuta-msft
Community Support
8 years ago

Hi bobsel,

 

To show a single value you selected in a slicer, you can use selectedvalue() function.

In addition, if you select multiple values in a slicer, you create a measure to achieve selected values using DAX below:

Measure = CONCATENATEX(ALLSELECTED(Table1), Table1[Date], ",")

 

Regards,

Jimmy Tao