How to Use Metrics in Power BI

Setting up dashboards in Power BI is a great first step, but a dashboard often shows you just a snapshot of your data. If you want to track progress toward specific business objectives over time, you need to use Metrics. This article walks you through creating and using Power BI Metrics (also called Scorecards) to monitor your KPIs, assign ownership, and keep your entire team aligned on your most important goals.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

What Are Power BI Metrics and Why Do They Matter?

You might see metrics, measures, and KPIs used interchangeably, but in the Power BI ecosystem, a "Metric" has a very specific meaning. A Metric is an individual, trackable goal that lives inside a sharable "Scorecard." Think of a Scorecard as a centralized hub for all your key performance indicators (KPIs).

Unlike a standard dashboard visual that just displays a number, a Metric is designed to track progress. Each Metric has:

• A clear owner responsible for it.
• A current value and a target value.
• A status (e.g., On track, At risk, Behind).
• A history of check-ins and notes.

So, why is this so useful? A regular report might show you this month's revenue, but a Scorecard shows you this month's revenue compared to the target, who is responsible for hitting that number, the progress made over time, and a log of all relevant actions taken. It transforms raw data into an actionable performance management tool.

This is perfect for goals like tracking quarterly sales quotas, monthly marketing lead targets, or website traffic growth. Instead of a static number on a dashboard, you get a dynamic, collaborative story about your performance.

Creating Your First Scorecard in Power BI

Before you can create metrics, you need a Scorecard to put them in. Setting one up is simple, but note that this feature is only available in the Power BI Service (the web-based version), not in Power BI Desktop.

Here’s how to do it:

1. Navigate to the Power BI workspace where you want to create your scorecard. This is typically a collaborative space for your team, like "Marketing Team" or "Sales Q3."
2. In the top left corner, click the New button and select Scorecard from the dropdown menu.
3. A dialog box will appear. Give your scorecard a clear, descriptive name like "Q4 Marketing Performance" or "Sales Team Weekly KPIs."
4. Optionally, add a description to give context for anyone else who might see it. For example, "Tracks key metrics for the marketing funnel, from website traffic to new leads."
5. Click Create. You'll be taken to a blank canvas, ready for you to start adding your metrics.

That’s it! Your Scorecard is now a living container in your workspace that you can share with your team. Next, we’ll start populating it with meaningful goals.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

A Step-By-Step Guide to Creating Your First Metric

This is where the real work happens. We'll build a metric from scratch, connecting it directly to an underlying Power BI report. For this example, let's say our goal is to achieve 50,000 monthly active users on our website. We already have a Power BI report built on Google Analytics data that shows this number.

Follow these steps to track that goal:

1. Add a New Metric

Inside your blank scorecard, you'll see a button that says New metric at the top. Click it to open the setup pane on the right side of your screen.

First, give your metric a name. It should be clear and concise. Instead of just "Traffic," name it something specific like "Monthly Active Users."

2. Assign an Owner

Every goal needs someone responsible for it. In the Owner field, you can assign the metric to anyone with access to the workspace. This person will receive notifications about the metric and is considered the primary person accountable for its performance. Let's assign this to the head of marketing.

3. Connect the Current Value to Your Data

This is the most critical step. You could just type a number into the Current value field, but the whole point of Power BI is automation. Let's pull the live value directly from our report.

• Click the Connect to data button next to the "Current" field.
• A window will appear, prompting you to "Browse your Power BI content." Use the search bar to find the Power BI report that contains your website traffic data.
• Once you open the report, you can click on any visual to see the underlying data points. It’s best practice to have a simple 'Card' visual in your report that just shows the single number you want to track (e.g., a card showing "45,210" for Monthly Active Users).
• Click that Card visual. The value will be selected. Click Connect.

The "Current" value in your metric is now dynamically linked to your report. It will update automatically whenever the underlying dataset refreshes. No more manual data entry!

4. Set a Target

Just like the current value, your Target value can be either manually entered or connected to data. For our example, the target is 50,000 users. We can simply type '50000' into the "Target" field. If your target was dynamic — for instance, based on a forecast in another report — you could use the Connect to data process again.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

5. Configure Status, Start Date, and Due Date

To give your metric timeline and context, fill out the final fields:

• Status: You can manually set a status like On track, At risk, or Behind. This adds a human element of context that data alone can't provide. Maybe the numbers are slightly behind, but you know a big campaign is launching tomorrow, so you set the status to "On track."
• Start date: The date when the tracking period for this goal begins.
• Due date: The deadline for achieving the goal.

Once you’ve configured everything, click Save. Your first metric will now appear in your scorecard, showing the current value against its target.

Using Check-ins to Track Progress and Add Context

A scorecard isn’t just for viewing data, it's for communication and collaboration. The 'check-in' feature is perfect for this. When you check in, you update a metric's status and can leave a note explaining what's happening.

For example, if the marketing manager sees that the "Monthly Active Users" metric has jumped by 5,000, they can open the metric, add a check-in, set the status to "On track," and add a note like: "The new blog content series we published on Monday is generating a significant amount of referral traffic. Performance is exceeding expectations."

This creates a historical log of actions and insights directly within the scorecard. When your boss asks why performance changed two weeks ago, the answer is right there attached to the data point.

To add a check-in:

1. Hover over the metric and click Add check-in.
2. Update the status from the dropdown.
3. Add your note in the text box.
4. You can even update the numeric value here if you're tracking it manually.
5. Click Save.

Looking at the check-in history provides a rich narrative around the numbers, which helps everyone on the team understand what is — and isn't — working.

Advanced Scorecard Techniques

Once you've mastered the basics, you can enhance your scorecards with some powerful features.

Breaking Down Metrics with Submetrics

Some goals are too large to be tackled as one item. Submetrics let you break down a primary metric into smaller, contributing pieces. For our "Monthly Active Users" metric, we could add Submetrics to track its main drivers:

• Users from Organic Search
• Users from Social Media
• Users from Paid Ads

The main metric becomes a roll-up of its children, and you can assign different owners to each submetric. This cascade creates incredible clarity, showing how individual efforts contribute to the overarching objective.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Automating Statuses with Rules

Manually setting the status for every metric can be tedious. Instead, you can create automated rules. Click the pencil icon to edit your scorecard and navigate to the Status rules tab.

Here, you can set up simple logic. For example:

• Rule 1: If (% of target complete) is greater than or equal to 95%, set status to On track.
• Rule 2: If (% of target complete) is between 80% and 94%, set status to At risk.
• Rule 3: If (% of target complete) is less than 80%, set status to Behind.

These rules automatically apply to all metrics in your scorecard, ensuring consistent, data-driven status reporting across the board.

Embedding Scorecards into Reports

Finally, to make your scorecards even more useful, you can bring them directly into your regular Power BI reports. In Power BI Desktop, you can add a Scorecard visual to a report page. This embeds the entire interactive scorecard right next to your detailed charts and tables, creating a complete performance overview in a single pane of glass.

Final Thoughts

Power BI Metrics and Scorecards elevate your reporting from simply showing data to actively managing and tracking performance against goals. By connecting metrics directly to your data, assigning clear ownership, and leveraging features like check-ins and Submetrics, you can build a truly collaborative and accountable data culture for your team.

While Power BI is a powerful tool for this, gathering and unifying all your marketing and sales data in one place can still be a heavy lift. At Graphed, we help you simplify that process. We connect directly to sources like Google Analytics, Shopify, Facebook Ads, and Salesforce to unify your data instantly. Then, you can use simple, natural language to build real-time dashboards and reports, saving you hours of manual work and allowing you to focus on tracking the metrics that actually drive your business forward.