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?