Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
Anonymous
Not applicable

Display a related values as comma separated values based on slicer selection

‎05-22-2023 10:16 PM

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 

Message 1 of 2
184 Views
0
1 REPLY 1
vicky_
Super User
Super User

‎05-23-2023 10:16 PM

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], ",")
Message 2 of 2
144 Views
0

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

View All