How to Create a Glossary in Power BI

Ever opened a Power BI report and seen a metric called "Revenue" on one page and "Total Sales" on another, and had no idea if they were the same thing? You're not alone. This confusion is common when there's no single source of truth for what your business metrics actually mean, and it can erode an organization's trust in its own data. This article will show you exactly how to solve that problem by creating a clear and accessible data glossary directly within Power BI.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Why a Power BI Glossary is So Important

Before jumping into the "how," it's helpful to understand the "why." A data glossary, sometimes called a data dictionary, is a centralized list of your key business terms and metrics along with their definitions. Think of it as a dictionary for your company's data. Without one, teams often operate with mismatched definitions, leading to confusion and flawed decisions.

Imagine this common scenario:

• The Sales team defines a "Lead" as anyone who filled out a contact form.
• The Marketing team defines a "Lead" as anyone who downloaded an ebook.
• The Finance team only cares about "Sales Qualified Leads" that have been vetted and are close to purchasing.

When leadership asks for a report on "new leads this quarter," the results will be completely different depending on who pulls the data. A glossary standardizes these terms, creating a shared language across the entire business. It ensures that when someone looks at a number in a Power BI report, they understand precisely what it represents, how it's calculated, and why it matters.

Building a glossary increases user adoption, reduces requests for clarification, and empowers new team members to get up to speed faster. It’s a foundational step in creating a data-driven culture built on trust and clarity.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Method 1: Using Built-in Descriptions for Tooltips

One of the easiest ways to add definitions is to use a feature that's already built into Power BI: the Description property. This method embeds your definitions directly into your data model, so they appear as helpful tooltips when users hover over fields in the report builder.

This is a great starting point because it places the definition exactly where the user needs it, at the moment they need it.

Step-by-Step Instructions:

1. Open the Model View: In Power BI Desktop, navigate to the "Model view." This is the icon on the left-hand side that looks like a collection of data tables.
2. Select a Measure or Column: In the Data pane on the right, find the table containing the metric you want to define. Click on the specific measure or column name. For example, you might select a measure called [Total Revenue].
3. Add Your Definition: With the field selected, look to the Properties pane (usually found below the Data pane). Find the "Description" box and type in a clear, straightforward definition. For [Total Revenue], you might write:
4. See It in Action: Switch back to the "Report view." Now, when you or another user hovers over the [Total Revenue] field in the Data pane, your description will pop up as a tooltip. It’s that simple!

Pros: This method is seamless and keeps the definitions right inside the PBIX file. The context is immediate and doesn’t require users to navigate elsewhere.

Cons: The definitions aren't centrally visible in a single list. You have to hunt for them by hovering over each field, and it’s impossible to export them all into a single document.

Method 2: Building an Interactive Glossary Page in Your Report

For a more visible and user-friendly experience, you can create a dedicated page within your Power BI report that acts as a full-fledged, searchable glossary. This method consolidates all your definitions into one place, making it easy for anyone consuming the report to find what they need.

The best part is that you can manage the glossary from a simple Excel or Google Sheet, so you don't have to open Power BI every time you need to make an update.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Step-by-Step Instructions:

1. Create a Data Source for Your Glossary: Start by creating a simple table in Excel, Google Sheets, or even a SharePoint List. It only needs two columns: Metric and Definition.
2. Connect Power BI to a New Data Source: In Power BI, go to the "Home" ribbon and click Get Data. Select the appropriate source (e.g., "Excel Workbook" or "Web" for Google Sheets) and connect to the file you just created. Load your glossary table into the data model.
3. Design the Glossary Page:
4. Add Finishing Touches: Consider adding a text box that explains how to use the glossary or a "Last Updated" card that pulls the latest date from your source file. This builds trust by showing users that the definitions are current.

Pros: It provides a centralized, searchable, and easily printable list for all report users. Managing the definitions in a separate file (like a SharePoint List) means a non-technical user can keep it updated without needing any Power BI skills.

Cons: It requires users to leave their data visuals and navigate to a separate page, which can momentarily interrupt their analysis.

Method 3: Linking to an External Company Wiki or Knowledge Base

If your organization already has a central knowledge base in a tool like SharePoint, Confluence, or Notion, it's often best to leverage it as your single source of truth. Instead of creating a separate glossary inside your report, you can simply link from Power BI to your existing documentation.

This approach prevents you from having to manage definitions in multiple places and ensures the entire company is working from the same playbook.

Step-by-Step Instructions:

1. Establish Your External Glossary: If you haven’t already, create a page in your knowledge base dedicated to your company's official metrics and terms. Make sure it's organized and easy for anyone to read.
2. Add a Help Button to Your Report: In your Power BI report, add a "Button," "Shape," or "Image" visual. A "?" icon works perfectly. Go to the "Format" settings for that object, find the "Action" options, enable it, and select "Web URL" as the type. Paste the URL of your external glossary page into the URL field.
3. Place the button somewhere visible and consistent on every page, such as in the header or footer, so users always know where to click for help.

Pros: This method promotes a true single source of truth for the entire company, not just for one report. It also keeps your Power BI files clean and is easily scalable as your analytics needs grow.

Cons: The primary drawback is that it redirects users away from their analysis, forcing them to open a different browser tab, which can be disruptive. Any changes to URLs in your knowledge base could also lead to broken links in your report.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Best Practices for a Truly Useful Glossary

Regardless of the method you choose, a glossary is only useful if it's clear and well-maintained. Follow these tips to get the most value out of your efforts.

• Write for Humans: Avoid overly technical explanations or DAX formulas in your definitions. Explain terms in plain English that a new employee in any department could understand. For example, instead of just stating the formula for "Customer Lifetime Value," explain what it represents and why it’s important for the business to track.
• Establish Clear Ownership: Decide who is responsible for keeping the glossary up-to-date. Is it the report creator? A central BI team? Documenting ownership prevents the glossary from becoming stale and obsolete.
• Be Consistent: Ensure terminology is uniform across all of your company’s reports. If you define "Active User" in one report, make sure every other report uses that same exact definition. Consistency is the primary goal.
• Include Business Context: A great definition doesn't just explain what a metric is, it explains why it matters. For a term like Lead Response Time, you could add context like, "We track this to ensure our sales team is engaging with potential customers quickly, which is a key driver of conversion rates."

Final Thoughts

Creating a data glossary in Power BI is a small investment of time that pays major dividends in clarity, trust, and user adoption. Whether you choose built-in descriptions, an interactive report page, or a link to an external wiki, the key is to provide one reliable source of truth so everyone is on the same page. It’s how you transform a confusing report into an empowering tool for data-driven decisions.

Building dashboards manually and then documenting every metric afterward can feel like double the work. This is why we created Graphed. We connect directly to your data sources like Google Analytics, Shopify, and Salesforce, allowing you to ask questions in plain English. Graphed then generates the reports and dashboards for you in seconds. Because we've already done the hard work of understanding the data structure, dashboards are generated instantly with clear metrics, which often removes the need for a separate glossary from the start, as confusion about which data drives which dashboard is completely eliminated.