cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
jli2727 Occasional Visitor
Occasional Visitor

Parent Child Reporting Visualizer

Hello,

I'm trying to find a method/visualization to enable the generation of a tabular report having a parent-child relationship.  This is to report on dynamics365 data such as Quote-Quote Details or Order-Order Details.

I have the data connection working and the data model correctly and am able to create a flat list containing all my required fields just not as formated required.

 

Report/visualization requirment is...

 

Quote 1 Field1 Field2 Field3 Field4

          Quote Details 1 Field1 Field2 Field3 Field4

          Quote Details 2 Field1 Field2 Field3 Field4

Quote 2 Field1 Field2 Field3 Field4

           Quote Details 1 Field1 Field2 Field3 Field4

          Quote Details 2 Field1 Field2 Field3 Field4

 

and so on.

 

I do not need any summation or calc at the either the parent or child level, just the means to present the data as shown above.

 

Is this possible in PowerBI natively or with a add-on?

 

Many thanks.

J

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Parent Child Reporting Visualizer

@jli2727,

 

You may try the Matrix visual.

Community Support Team _ Sam Zha
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

2 REPLIES 2
Community Support Team
Community Support Team

Re: Parent Child Reporting Visualizer

@jli2727,

 

You may try the Matrix visual.

Community Support Team _ Sam Zha
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

sthorburn New Member
New Member

Re: Parent Child Reporting Visualizer

I thought the Matrix Visualizer would have worked, but given you asked for no summation or calc (aggregation), and instead, just want to display parent and child field values independently from one another . . . I don't think this is possible with the Matrix Visualizer.  Maybe someone else on this board can suggest alternative approaches?

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors