Table Visualisation Grouping & Hierachy

[joginderpandha]

Hi All

I have a table in Excel that I'm trying to re-create in Power Bi. Reasonably straight forward apart from one section of the table.

This part of the table has three headers, initiation, design and deployment. Each header has two dates associated it with it, planned date and revised date. 

The table structure in Power Bi is shown as below, with the three headers, initiation, design and deployment sharing a row with respective planned and revised date alongside them:

I realise I need to transform the data somehow but am struggling to understand how. I've tried unpivoting to with no luck.

Any ideas?

[v-xjiin-msft · Accepted solution]

Hi @joginderpandha,

Did you mean this? 

Go to Edit Queries, Choose Description column, in Transform pane select Unpivot Other Columns.

Thanks,
Xi Jin.

[joginderpandha]

Thanks @v-xjiin-msft, it worked!