String together slicer hierarchy

[dwalex]

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 like to see:

New York Region: New York, New Jersey; Atlanta Region: Georgia, Florida;

Or perhaps as a single column table, one row per region:

New York Region: New York, New Jersey

Atlanta Region: Georgia, Florida

[dwalex]

Important to add that this is a very large Direct Query tabular model source, so whatever I build will have to be added to the model.

[dwalex]

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.

[selimovd]

Hey @dwalex ,

maybe check out the option to use a hierarchy in your slicer:

Add multiple fields to a hierarchy slicer - Power BI | Microsoft Docs

Would that be an option? Or do you want everything in a single field?

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic