Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
So I can't seem to find an answer to this anywhere... I have a series of measure that are reading the selected values of different slicers. I'd like to take these measures and combine them into a new single measure that separates their values with newlines. Here is a sketch of what I want to do:
HAVE:
measure_2 = "slicer value a; slicer value b; slicer value c"
measure_2 = "slicer value e; slicer value f; slicer value g"
measure_3 = "slicer value x; slicer value y; slicer value z"
WANT:
measure_4 = "measure_1: slicer value a; slicer value b; slicer value c
measure_2: slicer value e; slicer value f; slicer value g
measure_3: slicer value x; slicer value y; slicer value z"
Is there any possible way to do this? I think the CONCATENATEX function will probably be involved but I'm honestly pretty stuck. Thank you!
Solved! Go to Solution.
@Anonymous , try like
"Slicer a " & CONCATENATEX(values(Table[slicer value a]),Table[slicer value a]) & "Slicer b " & CONCATENATEX(values(Table[slicer value b]),Table[slicer value b]) & "Slicer b "
& CONCATENATEX(values(Table[slicer value c]),Table[slicer value c])
@Anonymous , try like
"Slicer a " & CONCATENATEX(values(Table[slicer value a]),Table[slicer value a]) & "Slicer b " & CONCATENATEX(values(Table[slicer value b]),Table[slicer value b]) & "Slicer b "
& CONCATENATEX(values(Table[slicer value c]),Table[slicer value c])
Hi @Anonymous ,
Can you share a screenshot of your current scenario and what are the expected results.
Regards,
HN
User | Count |
---|---|
14 | |
9 | |
7 | |
7 | |
6 |
User | Count |
---|---|
21 | |
11 | |
10 | |
10 | |
8 |