Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Nourhan
New Member

Power BI Parent grouping

‎04-22-2018 08:12 AM

 

Untitled.pnghello 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 

Labels:
Message 1 of 3
1,692 Views
0
1 ACCEPTED SOLUTION
v-yulgu-msft
Microsoft Employee
Microsoft Employee

‎04-23-2018 11:57 PM

Hi @Nourhan,

 

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

1.PNG

 

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.

3.PNG

 

Best regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Message 3 of 3
1,698 Views
0
2 REPLIES 2
v-yulgu-msft
Microsoft Employee
Microsoft Employee

‎04-23-2018 11:57 PM

Hi @Nourhan,

 

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

1.PNG

 

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.

3.PNG

 

Best regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Message 3 of 3
1,699 Views
0
danextian
Super User
Super User

‎04-22-2018 08:18 AM

Hi @Nourhan

Please provide a sample importable data, not an image

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










Did I answer your question? Mark my post as a solution!


Proud to be a Super User!









"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Need Power BI consultation, get in touch with me on LinkedIn or hire me on UpWork.
Learn with me on YouTube @DAXJutsu or follow my page on Facebook @DAXJutsuPBI.
Message 2 of 3
1,690 Views
0

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

View All