Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
MagikJukas
Resolver III
Resolver III

Bill of Material production schedule

Hello,

I need some help to build the following report.

 

I have a table with production dates by code.

Some of the material are the "fathers" of other products in the same list.

 

I would like to build two tables with dates and production quantities, one for the father and the other for the children.

Then, being able to see the children production, based on the what is selected in the Father table.

 

Unfortunately, the interaction among the two tables does not work.

I tried alternative solutions, but I got error messagges in the visualization.

 

Any advice or best practive to solve this kind of situation?

 

MagikJukas_1-1678113082885.png

 

 

MagikJukas_0-1678110418876.png

 

Regards

 

1 ACCEPTED SOLUTION

@MagikJukas 
Hope this is what you're looking for

1.png2.png3.png

View solution in original post

3 REPLIES 3
tamerj1
Super User
Super User

@MagikJukas 

If this is a sample dummy file can you share it?

here's the link.

I haven't understood yet how I can load it in here: 🤔

https://drive.google.com/file/d/11rULHWabeRXy6OGuM4Wqd8Aw2zK9W37F/view?usp=sharing

@MagikJukas 
Hope this is what you're looking for

1.png2.png3.png

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors