Display changes/differences visually with this data, is it possible?

[Anonymous]

Hi,

I'm requesting your best expertise now.

I'm in a production company and as the process moves forward changes occurs (as a natural part of the process). My question for you is whether it's possible to display those changes in Power BI?
I'll explain and show you in detail what I mean. 

So, I have 4 tables (A, B, C, and D) which you can see further down. 

And  the first picture below here is somewhat what I imagine the finished results to look like:

As you can see in the first section (the light-grey section). This is the initial data compressed and simplified (that the order starts with).
We can see hear that OP1934 started with 5 Stock Item Codes (L4589695, L568568,L8955884, L568559; L7896587). As the production process goes forward the team had to add 3 additional Stock Item Codes (L1111111, L2222222, L3333333) and they are shown in the light-blue field. The 5 has now become 7. 
The data I have imported into Power BI is real-time. That's why I stress the importance of wondering whether this set-up is "do-able"; one section with the initial data which is static (This is the light-grey section) and one section where the updates from the live-stream/real-time data is displayed (this is the light-blue section).

To display the changes then.... I'm then looking for and thinking something like this:

So, this all comes down to my main question:

Is there a way in Power Bi where you can construct a visual, table, anything similar to the one I constructed above, that displays the data like that?
Give me your best expertise and skills on this matter.

Many thanks!! 

DATA: Note! As I cannot upload a sample file, the data with its columns is presented below. 

TABLE A

Stock Item Code	Warehouse	Work Order Nr
L7896587	A	59642
L568559	A	59642
L8955884	A	59642
L568568	A	59642
L4589695	A	59642
L9365668	B	15537
L966556	A	63275
L1255954	A	63275
L688954	A	63275
L655821	A	44744
L9855544	A	44744

TABLE B

Operation Nr	Parent Stock Item	Quantity	Stock Item Code Component	Warehouse	Work Order Nr
OP1934	H986344	1	L7896587	A	59642
OP1934	H156686	1	L568559	A	59642
OP1934	H898568	1	L8955884	A	59642
OP1934	H952556	1	L568568	A	59642
OP1934	H555778	1	L4589695	A	59642
OP1971	H781556	1	L9365668	B	15537
OP1993	H493343	1	L966556	A	63275
OP1993	H985542	1	L1255954	A	63275
OP1993	H903434	1	L688954	A	63275
OP1969	H3489454	1	L655821	A	44744
OP1969	H855542	1	L9855544	A	44744

TABLE C

Date BOM Activated	Parent Stock Item	Quantity	Stock Item Code Component	Warehouse
2022-10-13	H986344	1	L7896587	A
2022-10-13	H156686	1	L568559	A
2022-10-13	H898568	1	L8955884	A
2022-10-13	H952556	1	L568568	A
2022-10-13	H555778	1	L4589695	A
2022-06-04	H781556	1	L9365668	B
2022-12-27	H493343	1	L966556	A
2022-12-27	H985542	1	L1255954	A
2022-12-27	H903434	1	L688954	A
2022-11-02	H3489454	1	L655821	A
2022-11-02	H855542	1	L9855544	A

TABLE D

Stock Item Code

L7896587

L568559

L8955884

L568568

L4589695

L9365668

L966556

L1255954

L688954

L655821

L9855544

[Anonymous]

Anyone?

[Anonymous]

@Anonymous 

Do you need any additional information other than the information above?

[Anonymous]

@Anonymous 

Here's my relations:

[Anonymous]

Hi @Anonymous ,

What are the relationships between these tables?

Best Regards,

Jay

[Anonymous]

@Anonymous 

Additionally, this info could be useful for you.

The Cardinality for one of the relationships (MPC Bill of Material and Stock Item Master Table) is 'Many to one' and Cross-filter direction' is single.

And for the other relationship (Work Orders and MPC Bill of Material) has the Cardinality: 'Many to many' and Cross-filter direction: 'Both*.