Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Currently the data is this. There are a other columns to the right but I need it to show in a PowerBI Table visual side by side below. Management wants to see in a Row format (some IDs there are 3 employees involved while some has only one). The data when imported from a sharepoint online list is the one shown below. I tried to Unpivot other columns but somehow it is not working. Is there a way to put the data side by side in a row as some project ID has several members involved and they want to know right. What is the best approach?
ID | Owner 1 | Owner2 | Owner 3 |
111 | Daniel C | Eric W | Chris Y |
In the Powerquery editor
Solved! Go to Solution.
I got it working using Table.Column([IDTest],"Owner")
Keep your data as is and just do a ConcatenateX as so:
I got it working using Table.Column([IDTest],"Owner")
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
87 | |
87 | |
87 | |
67 | |
49 |
User | Count |
---|---|
135 | |
113 | |
100 | |
68 | |
67 |