Forum Discussion

Neqom's avatar
Neqom
Frequent Visitor
2 years ago
Solved

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

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".  Feb...
  • amitchandak's avatar
    2 years ago

    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.