Forum Discussion
Formatting Data in a table
I'm not sure to understand your question because one of the basic rule of data analysis is to avoid blank cells
If you have all your cells populated in Power Query that great.
But to present your data with a hierarchy (like you want), you just have to use the tool Pivot Table in Excel or Matrix in Power BI desktop.
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.