How to Format a Column in Power BI

Properly formatting your columns in Power BI transforms a confusing table of numbers into a clear, professional report. It’s the difference between a raw data dump and actionable insights that your team can actually understand. This tutorial will walk you through the essential techniques for formatting columns, from basic number and date changes to more advanced conditional formatting.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Why Does Column Formatting Matter?

You can have the most accurate data in the world, but if it’s presented poorly, its value plummets. Imagine a financial report where revenue is just a string of numbers like 500000 instead of $500,000.00, or a sales report showing a conversion rate as 0.075 instead of 7.5%. It immediately forces your audience to stop and mentally interpret the data, breaking their flow and increasing the risk of miscommunication.

Good formatting provides immediate context. It makes your reports:

• Easier to Read: Clean, consistent formatting helps people scan data quickly and comfortably.
• More Professional: It shows attention to detail and builds trust in your reporting.
• Less Prone to Error: Clearly labeling units (like $, %, or dates) prevents misinterpretation and bad decisions.

Spending a few minutes on formatting can save hours of clarification down the line.

Where to Format: Report View vs. Power Query

Before you start clicking, it's important to understand the two primary places you can manage column formats in Power BI. Each serves a different purpose.

• Report View / Data View: This is where you format for presentation. The changes you make here affect how data looks in your tables, charts, and cards. You aren’t changing the underlying data itself, just its appearance. This is where you'll spend most of your time formatting currencies, percentages, and dates.
• Power Query Editor: This is for data transformation. The changes you make here alter the fundamental data type of a column. For example, changing a column from "Text" to "Whole Number" here is a permanent transformation step. You do this to ensure your data is in the correct format for calculations, not for visual styling.

A good rule of thumb is: use Power Query to set the correct data type, and use the Report View to set the visual display format.

Graphed

Still Building Reports Manually?

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

Watch the Demo

How to Format Columns in the Report & Data View

This is where you’ll handle most of your day-to-day display formatting. In Power BI Desktop, you can access these options by selecting your table or visual, then finding the column you want to format in the Data pane. Once you select the column, a contextual "Column tools" tab will appear in the ribbon at the top of the screen.

Here’s how to apply common formats:

Changing to Currency

Displaying financial data correctly is one of the most common and essential formatting tasks.

1. Select the column that contains your financial data (e.g., 'Sales' or 'Revenue').
2. In the "Column tools" tab, look for the Formatting section.
3. Click the dropdown menu that likely says "General" or "Whole number."
4. Select Currency from the list. Power BI will auto-apply your default currency settings.
5. To change the currency symbol (e.g., from $ to €), click on the dollar sign icon next to the format dropdown and choose the one you need. You can also adjust the number of decimal places here.

Formatting Percentages

Percentages are often stored as decimals (e.g., 0.25 for 25%). Making them readable is simple.

1. Select the column with the decimal values you want to show as a percentage (e.g., 'Conversion Rate').
2. Go to the "Column tools" tab.
3. In the Formatting group, simply click the percent sign (%) icon.
4. Power BI automatically multiplies the value by 100 and adds the percentage symbol. You can then adjust the decimal places as needed.

Adjusting Numbers (Decimals and Thousands Separators)

For large numbers, thousand separators are a must-have for readability.

1. Select your numeric column (e.g., 'Pageviews').
2. In the "Column tools" tab, ensure the Format is a number type like "Whole number" or "Decimal number."
3. Click the comma icon (,). This will add a comma as the thousand separator (e.g., changing 1234567 to 1,234,567).
4. For decimal numbers, you can specify the number of decimal points visible in the box next to the formatting options.

Applying Date Formats

Raw date formats can look messy (e.g., '1/15/2024 12:00:00 AM'). Power BI offers several clean alternatives.

1. Select your date column.
2. Go to the "Column tools" tab.
3. Click the dropdown menu under Format.
4. You'll see a list of predefined date formats, such as:
5. Choose the format that best fits your report's design and space.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Advanced Custom Formats with DAX's FORMAT Function

Sometimes the built-in options aren't quite enough. When you need a truly custom format, you can create a new calculated column using the FORMAT function in DAX (Data Analysis Expressions). This function is incredibly powerful for precisely controlling how your data appears.

The basic syntax is:

FORMAT( <value>, <format_string> )

Here are a few practical examples:

Custom Date Formats

Let's say you want to show the date as "Mon, Jan 15" to save space on a chart axis.

1. Right-click your table in the Data pane and select "New column."
2. Enter this DAX formula:

Formatted Date = FORMAT( 'Sales'[OrderDate], "ddd, mmm dd" )

This creates a new column with dates formatted exactly as you specified.

Shortening Large Numbers (K for Thousands, M for Millions)

This is very useful for cards and high-level charts where exact figures aren't necessary.

1. Create a new column.
2. Use a DAX formula with conditional logic:

Revenue (Short) = 
SUMX (
    factFinance,
    factFinance[Amount] /
    ( IF ( factFinance[Amount] < 1000, 1, 
        IF ( factFinance[Amount] < 1000000, 1000, 
        1000000 ) )
    )
)

Adding Prefixes or Suffixes to Numbers

You can also use DAX to combine text with a formatted number to create labels.

1. Create a new column.
2. Enter this DAX formula:

SKU Label = "SKU: " & FORMAT( 'Products'[SKU_ID], "0000" )

This would format an ID of 123 as SKU: 0123, padding it with leading zeros.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Using Conditional Formatting to Add Visual Cues

Conditional formatting allows you to dynamically change a column's appearance based on its value. This is one of the best ways to draw attention to important data points, such as high-performing products or regions that are falling behind target.

Let's walk through a common example: coloring cells in a sales table based on performance.

1. In the Report View, select your table or matrix visual.
2. In the Visualizations pane, find the fields well. Right-click on the value you want to format (e.g., 'Sales Amount').
3. Hover over Conditional formatting and choose an option like Background color.
4. A new window pops up. Here you can define the rules. In the "Format style" dropdown, choose Rules.
5. Now, set your logic. For example:
6. Click OK.

Your table will now be instantly color-coded, making performance analysis incredibly fast. You can use this same method to apply other conditional formats, including:

• Font color: Change the text color based on rules.
• Data bars: Adds horizontal bars within each cell, like an in-cell bar chart.
• Icons: Adds symbols like traffic lights, flags, or checkmarks based on values.

Final Thoughts

Mastering column formatting in Power BI elevates your reports from simple data tables to compelling, strategic business tools. By using the Report View for presentation, DAX for customization, and conditional formatting for visual storytelling, you can ensure your insights are clear, actionable, and trusted by your stakeholders.

While Power BI is a powerful tool, it has a significant learning curve. The process of connecting data, transforming it in Power Query, and manually formatting every column can be time-consuming, especially for busy teams that just need fast answers. This is precisely why we built Graphed. We automate the entire process by connecting to your data sources and allowing you to build and format reports using simple, natural language. You focus on the insights, not the setup.