how to structure excel data

Hello,

I am new to PowerBI and have a question re pulling data in from an Excel spreadsheet I am using, and how i am best to structure the data in excel to get BI to read it correctly.

Situation: each month we get reports in from the different departments in the business and these are put into a scoring matrix which pulls out an overall score. There are 3 'divisions' that we have split the business into, and inside each of these 3 divisions is 5 'silos' that we report against - the same 5 silos are across all 3 divisions.

Here are example graphs in Excel that show the points each division has received in this particular month. The top graph shows the overall score, and the bottom one has the same overall number but shows the breakdown by Silo. The 'Difference' numbers are the balance of points available to the max of 111.

We also show the data from the opposite perspective, showing the summary for each Silo, and the detail breakdown by Devision with each Silo.

What I would like to be able to do in BI is to combine the 2 graphs for each perspective so that I can just filter between summary/detail version on the same graph instead of having them separate.

Also if I could filter by month on the graph so we can look back at historical months.

So my main question is - how am I best to structure the Excel spreadsheet table so that BI can create the 2 graphs. Total for each Division; the total for each Silo; and the month which each score is for.

Would appreciate any guidance you can provide

Thanks in advance.