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 

May I ask if you have resolved this issue? If so, please share your insights and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster, otherwise please share some sample data so that we can take a look.

Thank you.

[jrhaney23]

Hi @v-nmadadi-msft,

We can mark this as resolved. After digging into my data a bit more, I found that it needs some refinement to make sense. Thanks for providing the posting tips below.

[v-nmadadi-msft · Accepted solution]

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.