I feel like this should be simple but perhaps i’m overthinking. I have a requirement to create a dashboard to present resource availability. The value respresented in each month’s column is a numver of resouces available for the month. Eg. 94/100 manpower was available in January, 80/100 in march. I want to create a dashboard where as the data is refreshed, the total resources are shown as and when they change and the availability of the month is refleced accordingly i.e. if the resources available go upto 150, and the availability in january is 90/150. the goal is to compare them against a benchmark of availability and see if we are maintaining the required amount of availability.

i need to know how to prepare the data in excel to do so, and how to further do so in powerquery if required.

Screenshot of dataset sample

I tried pivoting the data but it makes it difficult to show line charts in such a manner, which is an important chart to include in the visualization. I am struggling to find the ideal way to prepare the data for this scenarioScreenshot of pivot in PowerBI