Forum Discussion
Solved
Dynamic Title based on HierarchySlicer value
Is there a default/easy way to show the values chosen in a HierarchySlicer?
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
1 Reply
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