Showing results for 
Search instead for 
Did you mean: 
Helper II
Helper II

How to create a percentage capacity chart

Hi All


I m new to power bi so need your assistance in helping me create this chart.  I want to calculate the instrument utilization for my instruments. Instrument A has a throughput of 1000 tests/hour and Instrument B has throughput of 200 tests/ hour 


Instrument A can run only "CC" TESTS and Instrument B can run "IA" tests.


So i have a column in my data that is receive hour. I want to calculate the number of tests received in an hour.


And catergorize by test type so if the test type is "CC" then group it in instrument A

and if "IA" then Instrument B 


Also i want to have the flexibilty to choose the number of instrument needed i.e if i select 2 in my slicer for instrument A it shoudl take the throughput as 2000 not 1000 tests/hour.


The formula that i need to calculate the percent capcity is (Total number of tests received in that particular hour)/ Throughput of Instrument * Number of instrument selected)*100.


I have attached the example in excel was i want to createCapacity chart example.pngCustomer data.png

 Link for the data in excel.!AlMqyIwZH-2XamWX-zcahxcWHWc



From your description, I could not understand the sentence "So i have a column in my data that is receive hour. I want to calculate the number of tests received in an hour". I could not find any data about the column [receive hour], if the receive hour should be calculated, could you please tell me the logic about how to calculate your data? 



Daniel He

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi Daniel 


The column Receive hour is calculated column = Time.Hour (Receive date).


Let me know if you know how i can do this.



Helpful resources


2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

BizApps LATAM 2023

Business Application LATAM Summit 2023

Join the biggest FREE Business Applications Event in LATAM this February.

Power Platform Bootcamp

Global Power Platform Bootcamp

In this bootcamp we will deep-dive into Microsoft’s Power Platform stack with hands-on sessions and labs, delivered to you by experts and community leaders.