Forum Discussion
Formatting Data in a table
Hello I am trying to figure out how to get my table information to display like this: But my table ends up looking like this: p.s I asked a similar question previously, and...
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.