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". 
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%



Need Help
  • amitchandak's avatar
    amitchandak
    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.

2 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    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.