All fields in one cell in excel

[dineshj]

Hi, 

I have a list by client of the requested services. This document in excel lists all the services in one cell seperated by semicolon. How can I display this in a dashboard? The user would select the client and see list of all the services requested. 

Thank you for your help. 

[v-chenwuz-msft · Accepted solution]

Hi @dineshj ,

Can you provide some sample data and expect result?

Maybe you can use power query to split the string in one cell and unpivot them. Some steps like the following.

client	requested service
a001	service1;service2;service3
a002	physical1;physical2

split column-->

client	requested service1	requested service2	requested service3
a001	service1	service2	service3
a002	physical1	physical2	null

unpivot -->

client	requested service
a001	service1
a001	service2
a001	service3
a002	physical1
a002	physical2

Then measure like  this: 

all services = CONCATENATEX('Table',[service],",")

Result:

Pbix in the end you can refer.

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.