Graphed LogoGraphed
Graphed LogoGraphed
How It WorksAgentsIntegrationsPricing

How to Show Percentage in Card Power BI

Cody Schneider••8 min read

Showing a single, clear percentage in a Power BI card is one of the most common ways to highlight a key performance indicator (KPI). This article will guide you through the different ways to display percentages in a card visual, from simple formatting tricks to powerful DAX formulas for custom calculations.

GraphedGraphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Watch Graphed demo video

Why Use Percentages in Card Visuals?

Card visuals in Power BI are designed to make one number stand out. While showing total revenue or the number of users is helpful, a percentage often provides more context. A percentage compares one number to another, making it a powerful way to represent metrics like:

  • Market Share: Your sales as a percentage of the total market.
  • Growth Rate: The percentage increase or decrease in sales month-over-month.
  • Conversion Rate: The percentage of website visitors who made a purchase.
  • Budget Variance: How much a team is over or under budget, expressed as a percentage.

Displaying a simple "21.4%" can be far more insightful than showing two separate numbers for "Completed Tasks" and "Total Tasks" and forcing your audience to do the math in their head.

Method 1: Using a Pre-Calculated Percentage Column

The easiest scenario is when your data source already contains a column with percentage values. For instance, you might have a table with survey results where one column is 'Satisfaction Rate' and the values are already calculated as percentages. In this case, getting it into a Card is a simple drag-and-drop.

Here’s how you do it:

  1. On your Power BI canvas, select the Card visual from the Visualizations pane.
  2. Find your pre-calculated percentage field in the Data pane.
  3. Drag that field into the "Fields" bucket of the Card visual.

Power BI is usually smart enough to recognize the data type and display it correctly. If it shows up as a decimal (e.g., 0.85 instead of 85%), you need to format it.

  1. Click on the field name in the Data pane (not the visual itself). A new "Column tools" ribbon will appear at the top of the window.
  2. In the "Formatting" section of the ribbon, click the % symbol. You can also adjust the number of decimal places here.

This method is quick and easy but depends on the percentage being calculated before the data even gets to Power BI.

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Method 2: Formatting an Existing Measure as a Percentage

Often, you create a measure in Power BI that results in a decimal value, and you need to display it as a percentage. For example, if you calculate Profit Margin = Profit / Revenue, the result will be a decimal like 0.15. You want the card to show 15%.

The process is nearly identical to formatting a column:

  1. Select the Measure: In the Data pane on the right, find and click on the measure you want to format (e.g., your Profit Margin measure). Do not click the visual on the canvas.
  2. Use the Measure Tools Ribbon: Once you've selected the measure, the "Measure tools" context ribbon will appear at the top.
  3. Apply Percentage Formatting: In the "Formatting" section, find the dropdown menu that likely says "General" or "Decimal number". Click it and select Percentage. Alternatively, you can just click the % icon right next to it.
  4. Adjust Decimals: You can set the number of decimal points you wish to display.

Now, when you drag this measure into your card visual, it will automatically be displayed as a percentage. Applying the formatting at the measure level is best practice because it ensures the percentage formatting is consistent anywhere you use that measure in your report.

Method 3: Creating a New Percentage Measure with DAX

Most of the time, you'll need to calculate the percentage yourself using Data Analysis Expressions (DAX). This is the most flexible and powerful approach, as it lets you define exactly what your number means.

Key DAX Functions for Percentages

To get started, it's helpful to know two core DAX functions:

  • DIVIDE(): This is the safest way to perform division in DAX. Its syntax is DIVIDE(<numerator>, <denominator>, [alternate_result]). The great thing about DIVIDE is that it automatically handles division-by-zero errors. If the denominator is zero, it returns the optional alternate result you specify, or BLANK() if you don't. Using this is much safer than the standard / operator.
  • CALCULATE(): This function is the powerhouse of DAX. It changes the context in which a calculation is performed. You'll use it constantly to get the "total" part of a "percent-of-total" calculation.
GraphedGraphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Watch Graphed demo video

Example 1: Calculating Percentage of a Total

Let's say you want to show the percentage of sales that came from a single product category, like "Accessories". You have a measure for total sales, [Total Sales], and a table Products with a Category column.

Step-by-step:

  1. Create your new measure. Right-click on your table in the Data pane and select "New measure."
  2. Write the DAX formula. You want to divide the sales for the "Accessories" category by the sales for all categories. The CALCULATE and ALL functions work together to achieve this.
% Accessories Sales = 
DIVIDE(
    CALCULATE(
        [Total Sales], 
        'Products'[Category] = "Accessories"
    ),
    CALCULATE(
        [Total Sales],
        ALL('Products'[Category])
    )
)

Breaking down the formula:

  • The Numerator: CALCULATE([Total Sales], 'Products'[Category] = "Accessories") calculates your total sales but only for the rows where the product category is "Accessories."
  • The Denominator: CALCULATE([Total Sales], ALL('Products'[Category])) calculates total sales while completely ignoring any filters on the product category. This gives you the grand total to divide by.
  1. Format the measure. After committing the formula, select the new % Accessories Sales measure and use the "Measure tools" ribbon to format it as a percentage.
  2. Add it to your card. Drag your newly created and formatted measure into a card visual.

Example 2: Calculating Year-Over-Year (YoY) Growth

Another common use case is showing period-over-period growth. Let's calculate year-over-year sales growth. First, this assumes you have a calendar table in your data model marked as a date table.

Step-by-step:

  1. First, create a measure for last year's sales. This uses the time-intelligence function SAMEPERIODLASTYEAR.
Sales Last Year = 
CALCULATE(
    [Total Sales],
    SAMEPERIODLASTYEAR('Calendar'[Date])
)
  1. Now, create the YoY growth percentage measure. The formula for growth percentage is (Current Period - Previous Period) / Previous Period.
YoY Sales Growth % = 
DIVIDE(
    [Total Sales] - [Sales Last Year],
    [Sales Last Year]
)
  1. Format and add to the card. Format your YoY Sales Growth % measure as a percentage and drag it onto a card visual to prominently display your growth rate.

Troubleshooting Common Issues

My Card Shows 100% (or 0%) Incorrectly

This is almost always a context issue. It usually means both the numerator and denominator in your DAX formula are being calculated over the same set of data (so they are equal, resulting in 100%).

The solution is to use ALL(), ALLSELECTED(), or ALLEXCEPT() within a CALCULATE() function to correctly modify the filter context for the denominator, as shown in the Percentage of Total example above. Ensure your "total" part of the calculation is truly ignoring the filters you need it to.

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

My Card is Blank

A blank card usually means the result of your DAX formula is BLANK(). This often happens if the denominator in a DIVIDE() calculation is zero or blank. While this is often the desired outcome, sometimes you would rather display 0%.

You can use the optional third argument in the DIVIDE function to handle this:

YoY Sales Growth % = 
DIVIDE(
    [Total Sales] - [Sales Last Year],
    [Sales Last Year],
    0 
)

Now, if [Sales Last Year] is zero or blank, the card will display a 0% instead of BLANK().

Enhancing Your Card Visuals

Beyond just showing the number, you can make your percentage cards even more effective.

  • Give it a Clear Title: Instead of leaving the default category label, go to the "Format visual" pane. Under "Visual" -> "Category label", turn it off. Then, turn on the "Title" option and write a more descriptive name, like "Conversion Rate (Last 30 Days)."
  • Use the New Card Visual: Power BI has recently released a new Card visual that is much more flexible. You can add extra context with "reference labels." For instance, below your main YoY % card, you can add a reference label that shows the actual sales figures for this year and last year.
  • Use Conditional Icons: While you can't dynamically change the color of the number in a standard Card visual, you can use a Table, Matrix, or KPI visual configured to look like a card. The KPI visual is particularly good for this, letting you add a trend axis and color-coding based on whether the percentage has gone up or down.

Final Thoughts

Showing a percentage in a Power BI card is a fundamental skill for building impactful reports. Whether you’re simply formatting existing data or writing powerful DAX measures to calculate percent-of-total or year-over-year gains, these methods allow you to distill complex data into a single, easy-to-understand metric.

Creating these measures and visuals is a powerful way to monitor business health. For those who want these critical insights without the steep learning curve of tools like Power BI, we created Graphed. Instead of wrestling with DAX functions, you can just ask in plain English, "Show me our year-over-year sales growth percent as a KPI card," and get an answer instantly. We connect all your data sources so you can get real-time dashboards without the setup time.

Related Articles