Forum Discussion
Formatting Data in a table
Background--> There are a bunch of projects currently being worked on, and there are different team members per project. One project may have 2 BA's. 1PM and 0 TL's. Another project may have 1BA,1PM, and 1TL and so forth.
I can easily identify who is on each project, but the problem is when I attempt to display who is on a specific project I get a format that is undesirable.
For instance when I select the project "Bob's Buttons" I want to know who is on this project.
However, If I use a table my information comes back like this:
What I want is this:
Does that help?
I don't think you can do that in Power Query but with a Pivot Table it's a piece of cake.
1. Connect your source of data to Excel
2. Create a pivot table connect to your source of data
3. Drag & Drop the 3 fields in the "Rows" area
And that's it. Nothing more to do
There must be a way to do it in power Bi... either way what I ended up doing was putting each role in a seperate table and lined them up so it lokos as if it was one table.