Help with Visual Calculation - OTD%

[jrhaney23]

Needing help in creating a visual calculation to determine a certain customer's on-time delivery percentage (OTD%). I'm certainly new at using Power BI, but I'm interested in moving to this app instead of using just excel. Below is an example of what I'm looking for:

I would like to go from this simple, singular chart to something more dynamic that can view different (not necessarily multiple) customers.

As you can see, I'm almost there, but I'm not exactly sure how to calculate the value on the line y-axis here. I would like the values to be from 0-100% of course.

Any help is greatly appreciated!

[v-nmadadi-msft]

Hi @jrhaney23 ,

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information. Do not include anything that is unrelated to the issue or question.

Please show the expected outcome based on the sample data you provided.

How to Get Your Question Answered Quickly - Microsoft Fabric Community

How to provide sample data in the Power BI Forum - Microsoft Fabric Community

Thank you

[Ashish_Excel]

Hi,

Cannot understand your question.  Share the download link of the PBI file and show the expected result clearly.