Forum Discussion

Nourhan's avatar
Nourhan
New Member
8 years ago
Solved

Power BI Parent grouping

 

hello please i have this data on excel i want to work with it on power BI and i have the issue of having two headers and i tried the grouping by and everything nothing is worked here so please help i want to have the parent group is C1 and the children will be QTY,Sales and the blank column 

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

    Hi Nourhan,

     

    I would suggest you format source table structure to be similar to below:

     

    Then, load such a table into Power BI desktop, you can use a Matrix visual to display data. You should also drill down the last level.

     

    Best regards,

    Yuliana Gu

2 Replies

  • danextian's avatar
    danextian
    Super User
    8 years ago

    Hi Nourhan

    Please provide a sample importable data, not an image

    Also,  what are those highlighted rows in red and gray for?

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee
    8 years ago

    Hi Nourhan,

     

    I would suggest you format source table structure to be similar to below:

     

    Then, load such a table into Power BI desktop, you can use a Matrix visual to display data. You should also drill down the last level.

     

    Best regards,

    Yuliana Gu