Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
haypowerbi
Frequent Visitor

Percentage of a Total

Created a column of dates promised - date shipped to track ontime delivery. I want to create this into a percentage of the percent of ontime deliverys for distinct order no's. I tried first with a quick measure for filtered percentage and got some months greater than 100%. Any thoughts or suggestions would be greatly appreciated!

 

Day On Time = IF('Ontime Delivery'[Days Late]<=0,"On Time","Late")
 
Day On TimeLocationCount of ord_no
LateX12
LateY269
LateZ37
On TimeX60
On TimeY273
On TimeZ311

 

Untitled.png

4 REPLIES 4
haypowerbi
Frequent Visitor

It will be a line graph showing the percentages under 100% of orders completed on time

 

We are currently doing it in excel but want to bring it into bi

You cannot do a line chart across locations.  Line charts need a progressing x axis value (like a time series).

lbendlin
Super User
Super User


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

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.