Forum Discussion
Display a related values as comma separated values based on slicer selection
Data : I have Region and Country Columuns in Location table and im using Region slicer in report
Requirement 1: display the Country names as comma separated values in the Card Visual based on the Region value selected in slicer
1 Reply
vicky_Super User
use the CONCATENATEX function.
I'm not entirely sure what your data looks like, but I imagine it would be something like:Measure = CONCATENATEX(VALUES([Country]), [Country], ",")