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 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 |
3 Replies
- selimovd
Most Valuable Professional
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 regardsDenisBlog: WhatTheFact.biFollow me: twitter.com/DenSelimovic 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.
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.
