Power BI Parent grouping

[Nourhan]

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 

[v-yulgu-msft · Accepted solution]

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

[danextian]

Hi @Nourhan

Please provide a sample importable data, not an image

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