power bi
1 Topic
Planner Multiple Assigned Task Filter
Hello Community, I have a question related to Microsoft Planner Export to Excel function. It gives multiple assigned task values with semi colon as "Name1 Surname1; Name2 Surname2". It is recognized as one collapsed data. I want to be able to filter as two different person with this data so I can get correct "Members Assignment Chart". What is the best possible way for this? Additional Information These "Name1 Surname1; Name2 Surname2" persons are belong to a office365 group. So I tried to to export this data to an online Sharepoint list. The names are recognized as People inside the group. Then I tried to connect this to Power BI. But the values are recognized as a List. When I extracted the values, again it was recognized as one data in row.Solved2.9KViews0likes6Comments