What is a Conditional Column in Power BI?

If you've ever found yourself staring at a table of data wishing you could quickly group values into categories, you're looking for a conditional column. This simple but powerful feature in Power BI lets you create new, rule-based columns to categorize, label, or flag your data. This article will walk you through exactly how to create a conditional column in Power BI with a practical, step-by-step example.

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

What is a Conditional Column, Exactly?

Think of a conditional column as an "if-then-else" statement for your data table. It allows you to create a new column whose values are determined by the rules you define based on other columns in your table. It's like telling Power BI, "If the value in Column A meets this condition, then put 'X' in my new column. If not, maybe check for another condition, and if nothing matches, just put 'Y'."

You use this kind of logic all the time in everyday life:

• If a student's score is above 90, their grade is an 'A'.
• If a sales deal is worth more than $10,000, it’s a 'Large Deal'.
• If a project’s due date is in the past, its status is 'Overdue'.

Conditional columns let you apply this same logic to entire tables of data automatically, making it incredibly useful for:

• Data Categorization: Grouping sales figures into tiers like "High," "Medium," and "Low."
• Creating Labels: Labeling customers as "Active" or "Inactive" based on their last purchase date.
• Flagging Data: Creating a "Flag for Review" marker for entries with errors or missing information.
• Numerical Binning: Grouping ages into ranges like "18-25," "26-35," etc.

The best part? You can do all of this using a simple, user-friendly interface in Power BI's Power Query Editor, with no code required.

Before You Begin: Opening the Power Query Editor

Conditional columns aren't created in the main reporting canvas of Power BI. Instead, they are part of the data transformation process, which happens inside the Power Query Editor. This is where you clean, shape, and prepare your data before building visuals.

To open the Power Query Editor, go to the Home tab on the Power BI Desktop ribbon and click on Transform data.

Once you’re in the editor, you’ll see your data tables listed on the left. Select the table you want to add a column to, and you're ready to start.

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

How to Add a Conditional Column: A Step-by-Step Guide

Let's walk through a common business scenario. Imagine we have a simple sales table with data on Product, Units Sold, and Revenue. Our goal is to create a new column called "Performance Tier" that categorizes each sale as "Excellent," "Good," or "Standard" based on its Revenue.

Here are our rules:

• If Revenue is greater than $1,500, the tier is "Excellent".
• If Revenue is between $500 and $1,500, the tier is "Good".
• If Revenue is less than $500, the tier is "Standard".

Let's build it.

Step 1: Navigate to the "Add Column" Tab

With your sales table selected in the Power Query Editor, look at the ribbon at the top. Click on the Add Column tab. This is where you’ll find all the tools for creating new columns based on your existing data.

Step 2: Choose "Conditional Column"

In the "General" section of the "Add Column" tab, click the Conditional Column button. This will open the Add Conditional Column dialogue box, where we will define our rules.

This dialogue box is your command center. It looks intimidating at first, but it's very logical once you break it down.

Step 3: Name Your New Column

The first field is New column name. It's good practice to give it a clear, descriptive name. We'll call ours "Performance Tier."

Step 4: Create the First Rule (The "If")

Now, we'll build our first "if-then" statement. This section of the box asks you to define a logical test.

• Column Name: Click the dropdown and select the column you want to evaluate. In our case, this is Revenue.
• Operator: Choose the comparison. We want to check if the revenue is greater than a certain value, so we'll select is greater than.
• Value: Enter the number to compare against. For our "Excellent" tier, this is 1500.
• Output: Enter the text you want the new column to show if the condition is true. We'll type Excellent.

Your first rule should now read: If Revenue is greater than 1500 Then "Excellent".

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

Step 5: Add the Second Rule (The "Else If")

To add our "Good" performance tier, click the Add clause button. This creates a new "Else If" line for your next condition.

The magic of Power Query is that it processes these rules in order. Since we've already taken care of all revenue over $1,500, any data that reaches this second rule is already less than or equal to $1,500. This simplifies our logic.

Just fill in the fields for our second rule:

• Column Name: Revenue
• Operator: is greater than or equal to
• Value: 500
• Output: Good

This rule now reads: Else If Revenue is greater than or equal to 500 Then "Good". Power BI will test this statement only on the rows that did not meet the first condition.

Step 6: Define the Catch-All Value (The "Else")

Finally, we need to tell Power BI what to do with all the rows that didn't meet either of the first two conditions. This is what the last field, labeled Else, is for.

Any sale with revenue that isn't greater than $1,500 and isn't greater than or equal to $500 must be less than $500. So, we'll enter Standard into the "Else" box. This is our default value.

After defining all your rules, your dialogue box should now look complete. Click OK.

You'll see a brand new "Performance Tier" column at the end of your table, populated with the labels based on your rules. Success!

Step 7: Close & Apply

Don't forget this final, crucial step. To save your changes and bring this new column into your main Power BI report, navigate back to the Home tab in the Power Query ribbon and click Close & Apply. Your newly enriched data is now ready to be used in slicers, filters, and visuals.

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

Going Further: Conditional Columns with DAX

The Power Query Editor is fantastic for most conditional logic. However, what if you need more complex rules, like ones involving multiple columns with AND/OR logic? For example, "flag orders that are Excellent tier and were sold in the USA region."

While you can sometimes achieve this with multiple steps in Power Query, it’s often easier to create a calculated column using DAX (Data Analysis Expressions) directly in the Power BI report view.

Here’s the key difference:

• Power Query Conditional Columns are created during data refresh. They physically add a column to your table when the data is loaded. This is often better for performance, especially on large datasets.
• DAX Calculated Columns are created after the data model is loaded. They calculate on a row-by-row basis and are computed when you create them or when the data is refreshed. They are very flexible and powerful.

To create a DAX column, go to the Data view in Power BI, select your table, and click New Column.

For our example goal ("Excellent" tier AND in the USA), the DAX formula would look like this:

Priority Flag = IF( AND( 'Sales'[Performance Tier] = "Excellent", 'Sales'[Region] = "USA" ), "High Priority", "Standard Priority" )

This DAX formula uses the IF function combined with an AND function to check two conditions at once - something that isn’t possible with a single rule in the standard conditional column interface.

Practical Examples for Inspiration

Now that you know how it works, here are a few other ways you can use conditional columns to add value to your reports:

• Product Pricing Tiers: Group products into "Budget," "Mid-Range," and "Premium" categories based on their price.
• Lead Scoring: Categorize leads as "Hot," "Warm," or "Cold" based on website engagement metrics pulled from an analytics tool.
• Age Grouping: Convert a column of individual ages into demographic groups like "Under 18," "18-35," "36-55," and "55+".
• On-Time Delivery Status: Compare the Order Date with the Delivery Date to create a new column showing "On Time" or "Late."

Final Thoughts

Creating a conditional column in a Power BI report is a fantastic and accessible way to start enriching your data. By using the simple menu inside the Power Query Editor, you can turn raw values into meaningful categories that make your dashboards and charts clearer and more insightful.

Manually defining these groups and transformations in tools like Power BI is a fundamental step in building useful reports, but it's often one of many stages in getting from raw data to actionable insight. We built Graphed to dramatically shorten that path. Instead of clicking through menus to define rules, you can just ask a question like, "categorize revenue by performance tier" in plain English, and Graphed creates the report instantly from your connected data sources. This helps eliminate the manual overhead, allowing your team to get straight to analysis.