Forum Discussion

Dibbles25's avatar
Dibbles25
New Member
4 years ago

creating charts from imported data by inserting formulas

Hi, I am totally new to PBI and don't even know how to add or create formulas.

 

I have imported an SQL script into PBI Desktop that has given me loads of information. This information includes columns for students who have left, completed, achieved and passed etc.

I need to create bar charts or pie charts showing the percentages but this can only be done by using formulas.

 

E.G. 100 learners started a course, 80 of them completed and left the college but only 60 of those learners achieved.

 

The formula to use is Achieved/Leavers = 60/80 = 75%

 

How do I create a Bar or Pie chart based on formulas such as the above one?

 

Any help appreciated

Need Help

4 Replies

    • Dibbles25's avatar
      Dibbles25
      New Member
      4 years ago

      Thanks for the swift reply,

       

      I don't mind using a bar chart but how do I add a formula or create a new field to insert a formula?

       

      The SQL script I imported gave me 51 fields of data but none of those fields have the percentages I need.

       

      I need to do a formula based on field A divided by field B and display the results in a chart.

       

      I hope this makes sense?

  • Dibbles25's avatar
    Dibbles25
    New Member
    4 years ago

    So, I need to divide the total achieved numbers by the total completed learners to get the overall pass rate: =Achieved/Completed and it returns the Pass rate as a percentage. 

     

    I then need the results displayed in a chart