Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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")
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |