cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ResearchDev
Helper II
Helper II

The Data is this but need to show on a Powerbi table side by side Pivot not working

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?

IDOwner 1Owner2Owner 3
111Daniel CEric WChris Y

In the Powerquery editor

ResearchDev_0-1655896550251.png

 

2 ACCEPTED SOLUTIONS
NickolajJessen
Super User
Super User

Keep your data as is and just do a ConcatenateX as so:

NickolajJessen_0-1655899833060.png

 

View solution in original post

I got it working using Table.Column([IDTest],"Owner")

View solution in original post

2 REPLIES 2
NickolajJessen
Super User
Super User

Keep your data as is and just do a ConcatenateX as so:

NickolajJessen_0-1655899833060.png

 

I got it working using Table.Column([IDTest],"Owner")

Helpful resources

Announcements
November 2022 Update

Check it Out!

Click here to read more about the November 2022 updates!

Microsoft 365 Conference â__ December 6-8, 2022

Microsoft 365 Conference - 06-08 December

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power BI Dev Camp Session 27

Ted's Dev Camp

This session walks through creating a new Azure AD B2C tenant and configuring it with user flows and custom policies.