Forum Discussion
String together slicer hierarchy
I have a table of Regions (city names: New York, Atlanta, Seattle) and the states included in those regions. I need to present the user's multiple choices in that slicer as a single string of textI'd...
Yes, I'm familiar with the heirarchy in a slicer, as shown here:
PBIX showing question
I'm trying to get the choices made in the slicer to appear as text in a measure or as rows in a table. I know how to CONCATENATEX the regions or the states, but not to iterate through the regions and string together the region's states into a single text value.