How to Show Increase or Decrease in Power BI

Seeing your total sales for the month is good, but knowing if that number is up or down from last month is what drives action. Visualizing increases and decreases in Power BI transforms your static reports into dynamic stories about performance and momentum. This tutorial will walk you through exactly how to calculate and display these changes using DAX measures, card visuals, and conditional formatting.

Graphed

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.

Build Your First Agent

Why Visualizing Change Is a Game-Changer

Numbers on a screen are just that - numbers. Without context, they don't tell you much. Is $50,000 in monthly revenue fantastic or a cause for concern? The answer depends entirely on what you did the month before. Tracking changes over time is fundamental to data analysis for a few key reasons:

• Performance Tracking: It's the most straightforward way to see if you're hitting your goals. Are your marketing efforts increasing leads? Is your new sales strategy boosting revenue? Viewing the percentage change makes the answer obvious.
• Spotting Trends: A single drop in sales might be a fluke, but three consecutive months of decline is a trend that needs investigation. Visualizing these changes helps you identify patterns early.
• Clearer Communication: Showing a stakeholder a chart with a green arrow pointing up and a "+15%" label is instantly understood. It's far more impactful than just showing two numbers and leaving it to them to do the mental math. It tells a clear story about growth or decline.

In short, visualizing the delta - the change between two points - is how you move from simply reporting data to gaining actionable insights.

The Foundation: Calculating Variance with DAX

Before you can show a change, you need to calculate it. In Power BI, this is done using Data Analysis Expressions (DAX). Don't worry if you're new to DAX, we'll break it down one step at a time. Our goal is to create measures that calculate the difference between the current period and a previous period (like last month).

Step 1: Get Your Data Model Ready

To perform any time-based calculations, you need a solid data model. This typically means two things:

1. A Sales or Fact Table: This is the table containing the numbers you want to analyze, like Sales Amount or Units Sold, along with a date for each transaction.
2. A Calendar or Date Table: This is a dedicated table that contains a continuous list of dates. It's a best practice in Power BI. You should mark it as a date table in your model and connect its date column to the date column in your sales table. This enables powerful time intelligence functions.

For our example, let's assume you have a Sales table with a SalesAmount column and a Date column linked to your Calendar table.

AI Agents for Marketing

Crash Course

Graphed

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.

Download the PDF

Step 2: Create a Base Measure

First, ensure you have a base measure for the value you're analyzing. It’s better to use an explicit measure than to drag and drop raw columns into visuals.

In the DAX formula bar, create a measure for total sales:

Total Sales = SUM(Sales[SalesAmount])

Step 3: Calculate the Previous Period's Value

Now, we need to create a measure that calculates the sales for the previous month. We'll use the powerful CALCULATE function combined with a time intelligence function like PREVIOUSMONTH or DATEADD.

Here’s the DAX for getting last month’s sales:

Previous Month Sales = CALCULATE( [Total Sales], PREVIOUSMONTH('Calendar'[Date]) )

This formula tells Power BI: "Calculate the [Total Sales] measure, but shift the date context back by one month."

Step 4: Calculate the Percentage Change

With both Total Sales and Previous Month Sales calculated, we can now figure out the percentage change. The formula is (Current - Previous) / Previous. We should also wrap it in the DIVIDE function to gracefully handle cases where the previous month's sales might be zero, preventing division-by-zero errors.

Here is the final DAX measure:

Sales % Change vs PM = DIVIDE( [Total Sales] - [Previous Month Sales], [Previous Month Sales] )

Once you’ve created this measure, remember to format it as a percentage from the Measure tools ribbon.

3 Easy Ways to Visualize the Increase or Decrease

Now that you have your % Change measure, it's time for the fun part: visualizing it. Here are three effective techniques, ranging from simple to more advanced.

Graphed

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.

Build Your First Agent

Method 1: Display with a Card or KPI Visual

The simplest way to show a metric is with a Card visual. Drag your Sales % Change vs PM measure onto a Card visual. It will immediately show the percentage change for the latest period in your report context. This is great for high-level dashboard summaries.

For an upgrade, use the KPI visual. This visual is designed to show progress against a target.

• Value: Drag in your Total Sales measure.
• Trend axis: Add your Date column from the Calendar table here. This is what generates the background line chart.
• Target: Drag in your Previous Month Sales measure.

The KPI visual will automatically calculate the percentage difference between the Value and Target and display it with color-coding — green for an increase and red for a decrease. It effectively combines your base value, your trend, and the percentage change all in one.

Method 2: Use Conditional Formatting in Tables or Matrices

This is arguably the most powerful and common way to show changes. When you have a report that breaks down performance by product, region, or marketing campaign, you can show the variance for each row.

Using Up/Down Arrow Icons

Let's add indicators to a simple table. Create a table that shows Product Category and your Sales % Change vs PM measure.

1. Select the table visual to activate it.
2. In the Visualizations pane, right-click on your Sales % Change vs PM field under the "Fields" well and select Conditional formatting > Icons.
3. In the formatting window, set up the rules. You want an up arrow for positive numbers and a down arrow for negative numbers.

• For the first rule, choose a red down arrow icon. Set it to show if value is ≥ (a large negative number) and < 0.
• For the second rule, add a yellow horizontal arrow icon. Set it to show if value is = 0.
• For the third rule, add a green up arrow icon. Set it to show if value is > 0 and ≤ (a large positive number).

1. Click OK. Your table will now have a clear visual indicator next to each percentage, making it easy to scan for wins and losses. You can even choose to show the icon only, making for a very clean look.

Using Background Color (Heatmap)

Another great conditional formatting option is background color. This creates a heatmap effect, making the largest increases and decreases stand out instantly.

1. Right-click your % Change measure in the table again, but this time select Conditional formatting > Background color.
2. In the format window, choose "Gradient." Power BI will suggest a default format.
3. For the best result, click the Add a middle color option.

• Set the Minimum color to red for negative changes.
• Set the Center color to white or cream. Manually set the custom value to 0.
• Set the Maximum color to green for positive changes.

1. Let Power BI handle the min and max values automatically. Click OK.

Now your table will have cells shaded from red (large decrease) to green (large increase), drawing your audience's eye directly to the most significant results.

AI Agents for Marketing

Crash Course

Graphed

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.

Download the PDF

Method 3: Create a Dynamic Arrow Measure with DAX

For complete control, you can create a measure that returns an arrow symbol as text. This allows for more customization than the built-in icons.

First, create a new DAX measure that uses an IF statement and the UNICHAR function to return the correct arrow character based on your percentage change measure:

Sales Change Arrow = IF( [Sales % Change vs PM] > 0, UNICHAR(9650), -- Up arrow ▲ IF( [Sales % Change vs PM] < 0, UNICHAR(9660), -- Down arrow ▼ UNICHAR(9644) -- Horizontal bar for no change ) )

Next, create another measure to control the color of that arrow:

Arrow Color = IF( [Sales % Change vs PM] > 0, "green", IF( [Sales % Change vs PM] < 0, "red", "orange" ) )

Now, add the Sales Change Arrow measure to your table. To apply the color, follow these steps:

1. Select the table, then find the Sales Change Arrow field in the Visualizations pane.
2. Right-click on it and choose Conditional formatting > Font color.
3. In the dialog that opens, change the "Format style" to Field value.
4. In the "Based on field" dropdown, find and select your Arrow Color measure.
5. Click OK.

You now have a fully dynamic, color-coded arrow column that's completely controlled by your DAX logic!

Final Thoughts

Showing an increase or decrease in Power BI is all about calculation and visualization. By starting with a solid foundation of DAX measures for variance, you can unlock a variety of compelling visuals using KPIs, tables with conditional formatting, and even custom formatting measures to clearly communicate business performance and tell a meaningful story with your data.

While Power BI is a fantastic tool for this kind of deep analysis, building these DAX measures and configuring visuals takes time and has a definite learning curve. Sometimes, you just need a quick answer. That's where we've streamlined the process. With an AI data analyst like Graphed , you can simply ask, "What was my sales percentage change week-over-week for the last quarter?" and get a dashboard built for you instantly – no DAX required. It's about bridging the gap between your data and the immediate insights you need to make decisions.