Attached is an Excel Table that I have to work with.

The object is to create a dashboard and a Gantt chart.

Obviously the Table structure is not suited for creating Pivot Tables and slicers. So I was trying to use PQ to Transform the table into something usable.

The Dashboard would need to show  Tasks counts for each Status, Projects Overdue, Milestones Overdue, Tasks Overdue, Tasks Completed late, etc. etc. all in the form of charts, with slicers for Project & Milestone.

The Gantt Chart would show Progress for each Project, Milestone Progress for each Project and Task Progress & Status for each Milestone.

The main issue I came across was if I used Fill (Up & Down) then I could get somewhere towards a usable table for pivots and pivot charts, but that made it useless for the Gantt chart.

Is there a way of using a single PQ, or would I need multiple PQs.

Hope somebody can give me some guidance.

TIA