Setup data model which allows to interact easily

Hi,

I'd appreciate some pointers on how to create visuals that illustrate how site capacities alter when there are numerous moves taking place. The goal is to present various possibilities so that the viewer may select the most appropriate one.

I'm trying to create a data model that will allow me to think about the following:

• Site storage capacities
• Brands stored in Sites
• Stock moves 
• External Storage
• View evolution of pallet movements during Months of the year

E.g. Scenario 1:

Site 1 storage fullness is at 92%, Site 2 49% and Site 3 is 72%, if i move Brand 11 out from Site 1 and Site 3 into Site 2 visuals would show new % of fulness for each site on the same Graph. 

Scenario 2:

External storage 1 moves into Site 2 or half of the volume moves into Site 3

Scenario 3:

Stock move 1 Moves into Site 3 or Site 2

Scenario 4:

Site 3 does Stock Move 1 gradually, total to move 1429 pallets but we decide to Move 457 in July and 457 in August and September 476 so total in Site 3 for September month will be 1429. Following month pallet holding is reducing because we ship them out.

I'd appreciate any help you can give me in making this. Site and offsite storage capacities, as well as the number of pallets that can be moved, should each be maintained in their own separate, editable file.

Please see below link to Excel file which i want to replicate in power bi.

Need Power BI view of this.xlsx - 

Password is Powerbi123

Kind regards

Martins