Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Anonymous
Not applicable

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 1
vicky_
Super User
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], ",")

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.