Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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 |
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.
Yes, I'm familiar with the heirarchy in a slicer, as shown here:
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.
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?
User | Count |
---|---|
53 | |
45 | |
19 | |
16 | |
14 |
User | Count |
---|---|
108 | |
56 | |
29 | |
21 | |
17 |