Forum Discussion
Solved
Unique values dynamically linked to multiple value columns
I am trying to transform data from a SharePoint list in Power Query Editor. That List has several single value columns and several multiple choice value columns. What I would like is to have those mu...
Hi user180618
Check this file: Download PBIX
Did I answer your question? Mark my post as a solution!
Ricardo
I've gone with extracting and concatenating the values, so now have:
| Name | Age | Location lived | Languages spoken |
| John | 30 | New York,Chicago | English,Italian |
| Ben | 35 | New York,Seattle,Portland | English,French |
| Jerry | 40 | San Francisco,Los Angeles | English,Spanish |
However, when I create a report and under Legend choose the column 'Location lived' and choose 'Count of Name' under Value, I cannot get it to show me the Location lived and Languages spoken values separately. So for example, I'd like a pie chart visualization for Ben to show me 1 count each for New York, Seattle and Portland, and 1 count each for English and French.
Is there a way to do this without running an R script in Query Editor?