Forum Discussion

joginderpandha's avatar
joginderpandha
Frequent Visitor
8 years ago
Solved

Table Visualisation Grouping & Hierachy

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?

Need Help
  • v-xjiin-msft's avatar
    v-xjiin-msft
    8 years ago

    Hi joginderpandha,

     

    Did you mean this? 

     

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

     

     

    Thanks,
    Xi Jin.