A Power BI vendor performance scorecard built on receipts
A Power BI vendor performance scorecard rates each supplier on delivery, quality and price from the transactions you already record. Buyers use it in supplier reviews, so the talk rests on evidence instead of impressions. Our consultants build the model inside your own Microsoft tenant, agree the scoring rules with you in writing and show progress every week.
- On-time and in-full delivery
- Reject rate by supplier
- Weights you control
Last updated
What is a Power BI vendor performance scorecard?
Every buyer has a view on which suppliers deliver and which ones cause trouble. However, views differ, and memory favors the last incident. A scorecard replaces that with a record built from purchase orders, receipts and inspections.
The idea is simple. Each supplier gets a result on a few measures, such as on-time delivery and reject rate. Then those results combine into one score by agreed weights. So suppliers can be ranked within a category and tracked over time.
The score opens the conversation, but the detail wins it. Therefore each figure drills through to the late receipts or rejected lots behind it. When a supplier disputes a number, the buyer can show the exact lines. If suppliers should see their own results in a portal, power bi embedded is the usual route.
Supplier measures that feed the score
The definitions are standard, while tolerances and weights are yours to set.
On-time delivery
Divide receipt lines that arrived by the promised date, within your tolerance, by all receipt lines.
In-full delivery
Divide lines received at the ordered quantity, within tolerance, by all lines. Short and over deliveries both count against it.
Reject rate
Divide quantity rejected at inspection by quantity received from that supplier.
Purchase price variance
Subtract the standard or agreed price from the actual price, then multiply by quantity bought.
Lead time
Measure days from order date to receipt date. Also compare the result with the lead time the supplier quoted.
Weighted score
Scale each measure to a common range, multiply by its weight and add the results into one rating.
How do you model a vendor scorecard in Power BI?
The model reads three sets of rows. Purchase order lines carry the promised date, ordered quantity and price. Receipt lines carry the actual date and quantity. Inspection results carry accepted and rejected quantities. All relate to supplier, item and date tables.
One choice shapes on-time delivery more than any other: which date counts as the promise. The original requested date, the supplier's confirmed date and a later revised date give three different answers. So we agree the rule with purchasing first and print it on the page.
Weights should be easy to adjust. We store them in a small table, or we use what-if parameters, which Power BI Desktop provides. Then a category manager can test how the ranking shifts when quality counts for more. A low-volume filter also helps, since one late delivery out of two distorts a rate.
Mistakes in a Power BI vendor performance scorecard
A scorecard loses credibility with suppliers when these six faults appear.
- Measuring against a promise date that buyers keep revising
- Rating suppliers with only a handful of receipts
- Blaming a supplier for delays your own receiving dock caused
- Ranking suppliers from unrelated categories against each other
- Hiding the weights and rules from the people being scored
- Showing a score with no route to the lines behind it
How we build a Power BI vendor performance scorecard
The rules come before the visuals, because a fair score depends on them.
Agree measures and weights
First purchasing and quality decide the measures, tolerances, promise date rule and starting weights.
Connect purchasing data
We read orders, receipts and inspections from your ERP through a supported route.
Calculate and test scores
Next we build the measures and the weighted score, then test several suppliers against known history.
Design the scorecard pages
Finally we lay out a ranking matrix, a supplier page and a drill-through list, and hand over the file.
Vendor scorecards in Power BI: common questions
Can we share a Power BI vendor performance scorecard with suppliers?
Yes, in several ways. The simplest is an exported page or a paginated report for each supplier. Power BI also supports sharing with external users, and row-level security can limit each one to their own data. License rules apply to external readers, and Microsoft Learn explains them. We go through the options with you.
How does vendor performance differ from a procurement page in Power BI?
A procurement page follows your own spend and process: what you buy, from whom and how quickly orders move. The scorecard rates the supplier's side: delivery, quality and price discipline. They share the same tables. So both can sit in one model, with the scorecard as a focused set of pages.
Can we add measures that are not in the ERP?
Yes. Some teams rate responsiveness or documentation by a simple periodic survey. Those ratings can live in a structured list, for example in SharePoint, and load into the model. However, we mark them as judgment scores on the page, since they differ in nature from measured results.
How do you keep small suppliers from skewing the ranking?
We apply a minimum activity rule. Suppliers below a chosen number of receipt lines in the period appear in a separate list without a rank. In addition, the page shows the count of lines beside each rate. As a result, a reader can judge how much evidence supports the score.
How do we start?
Ask for the free 30-minute assessment. We reply within 2 hours and follow with a written fixed scope. Power BI Agency is a division of Sataware Technologies, independent of Microsoft, and does not resell licenses. A small team works online and holds a demo every week.
Let's build your first dashboard together.
Tell us what you report on today. A consultant replies within 2 hours with next steps.
Trusted partners
Microsoft Solutions Partner · AWS Partner
Cloud & AI Platforms
Azure SQL, Microsoft Fabric and the data pipelines behind your reports.
AI Business Solutions
Power BI reporting on your Dynamics 365, Business Central and Power Platform data.
Security
Row-level security and Entra ID sign-in on every report and workspace.
Amazon Web Services
Power BI on your AWS data, with connectors for Redshift, Athena and S3.