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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel1

Power BI Monthly Update - May 2024

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

Top Kudoed Authors