Forum Discussion
Helper IAll fields in one cell in excel
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.
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.
1 Reply
- v-chenwuz-msft
Community Support
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.