Power Bi Line Chart Show Percentage per x-axis category instead of Grand Total

[Neqom]

For the On Time Trend I need to show the percentage of PO that have the status = "Ontime" per month instead of grand total.
Example: 
January 2023 has a total of 100 PO and 70 were "On time". 
February 2023 has a total of 50 PO and 40 were "On time". 

Graph should display January 70%, February 80%
Graph currently display January 46.6%, February 26.6%

[amitchandak · Accepted solution]

@Neqom , Assume you have two measures ontime and total PO

Then it should be a measure

% = Divide([OnTIme], [Total PO])

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[Neqom]

I don't have any measures. The fields "Po Number","Requested Date" and "Status" are fields in the same table.


https://drive.google.com/file/d/1On1AZt6bgkuPCWmhoegZ5LNs3xmhUIFI/view?usp=sharing


There it is sample data with those 3 columns. PO Number appears multiple times since every PO number has multiple lines.