cancel
Showing results for
Did you mean:

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a \$100 discount. Register Now

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 create

Link for the data in excel.

https://1drv.ms/x/s!AlMqyIwZH-2XamWX-zcahxcWHWc

2 REPLIES 2
Employee

Hi @SINGHTX9,

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?

Regards,

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.
Helper II

Hi Daniel

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

Announcements

#### Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

#### Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

#### Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

#### Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors