Forum Discussion
Using data from SharePoint list column with multiple values in Power BI visualisation
Another alternative is to use a more formal data modeling approach and create a cross-reference file. We show how to do this in the blog post. It may give you some different ideas on how to approach the problem.
https://marqueeinsights.com/how-to-work-with-sharepoint-multi-value-columns-in-power-bi/
Hope this helps!
--Treb, Power BI MVP
hi mrhooki
For "what projects project member x is involved with",
You could create a new measure as below:
Project for each member = var _table=CALCULATETABLE(VALUES('Table'[Project]),FILTER('Table','Table'[Project Members.1]=SELECTEDVALUE('SlicerTable Project member'[Uniquemembers]) ||'Table'[Project Members.2]=SELECTEDVALUE('SlicerTable Project member'[Uniquemembers]) ||'Table'[Project Members.3]=SELECTEDVALUE('SlicerTable Project member'[Uniquemembers]) ||'Table'[Project Members.4]=SELECTEDVALUE('SlicerTable Project member'[Uniquemembers]))) return
CONCATENATEX(_table,[Project],";")Then drag [Uniquemembers] field and this measure into a table visual.
For who is involved in project x
You just need to drag this measure[Project for each member] into a table visual and set filter is not blank
Here is a sample pbix file, please try it.
Regards,
Lin
v-lili6-msftthanks for the effort, but I was not able to make the solution work (might very well be due to a mistake on my side) and discovered that creating a reference table solved the problem without programming/measures.