Relative Content

Tag Archive for excelpowerquerydata-manipulation

How do i manipulate the excel data below to visualize monthly resource availability in powerBI?

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.