Forum Discussion
Unique values dynamically linked to multiple value columns
Hi user180618
Check this file: Download PBIX
Did I answer your question? Mark my post as a solution!
Ricardo
Why don't you split the values by comma, so you can achieve it.
Did I answer your question? Mark my post as a solution!
Ricardo
I've already split them by commas in Query Editor (see previous post), but it comes out like this in the report:
I'd like it to show me the count value for those cities separately, but for the Name column to be the main aggregator.
Hi user180618
Check this file: Download PBIX
Did I answer your question? Mark my post as a solution!
RicardoThanks camargos88. I've done as you suggested: Extracted and concatenated, and then Split Column by delimeter. But I now get several separate Locationslived.1 and Locationslived.2 columns.
My next question is: How should I group the columns so that the report can get all of those values together (instead of adding every split column to the Legend)? If in Query Editor I select Locationslived.1, Locationslived.2 and so on and group by Sum, I get an Error. If I group by All rows, I just get a [Table].
(Again, bearing in mind these Locations columns are multiple choice values relating to one Name column value)
Hi user180618 ,
You have to split it on rows and not on columns, if you split it using columns you can't use both to aggregate as you want.
Take a look at the file again, it has a step splitting both columns on rows instead of columns.
Ricardo