Solved: Planner Multiple Assigned Task Filter

Anonymous · ‎08-01-2019

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 gorup. 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. The image is below.

v-frfei-msft · ‎08-01-2019

Hi @Anonymous ,

Please expand the data by click the icon.

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.

View solution in original post

Anonymous · ‎08-02-2019

Hİ @v-frfei-msft ,

Thank you for the solution offer. I expanded the excel data as rows with Split Column button. This option worked for my raw excel data. So, I eliminated the Sharepoint list step.

For planner reporting, going with the row option is very useful since it is possible to count distinct values of rows. Planner Export option gives unique task id for this purpose I believe.

Thanks again for your help.