How to Center Values in Power BI Table

Nothing clutters a business report faster than a poorly formatted table. If you want your Power BI tables to look clean, professional, and easy to read, centering your values is a great place to start. This tutorial will walk you through a few different methods for centering your data in Power BI tables, from simple formatting adjustments to more advanced techniques.

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 Bother with Alignment in Power BI?

In data visualization, details matter. Standard practice is to left-align text and right-align numbers. This makes long columns of text easy to scan and numbers simple to compare at a glance. However, there are excellent reasons to intentionally break this rule:

• Improved Readability: For tables with just a few rows or columns, like a summary of Key Performance Indicators (KPIs) on a dashboard, center alignment can make the data points stand out and look less cramped.
• Symmetrical Design: Center-aligned headers and values create a balanced, tidy look that can feel more professional and intentional. It draws the eye toward the center of the cell, which is perfect for single, important values.
• Visual Hierarchy: Deliberately centering certain values (like status indicators or single-word descriptions) can set them apart from the rest of the data, signaling to your audience that these values are particularly important.

Method 1: The Quickest Fix using the Format Pane

The simplest way to center values is through Power BI's built-in formatting options. This approach is perfect when you need to align an entire column without any special conditions.

Handling a Specific Column

Let's say you have a table showing sales data, and you want to center the 'Units Sold' column.

1. Click on your table visual to select it. This will make the Visualizations pane active on the right-hand side of your screen.
2. In the Visualizations pane, click the paintbrush icon to open the Format your visual tab.
3. Expand the Specific column section.
4. From the 'Series' dropdown menu, select the column you wish to center (e.g., Units Sold).
5. A set of options will appear for that specific column. Find the Alignment section and click the center icon.

Instantly, all the numeric values in your 'Units Sold' column will shift to the center of their cells, giving your table a more balanced appearance.

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

Aligning Your Column Headers

What about the headers? Unbalanced headers can make an otherwise well-formatted table look off-center. Thankfully, aligning them is just as easy.

1. Make sure your table visual is still selected.
2. In the Format your visual pane, expand the Column headers section.
3. Under the 'Text' options, you'll see Text alignment. Choose the center icon.

All of your column headers will now be perfectly centered, matching the values you just aligned.

Method 2: Centering with Conditional Formatting Icons

Sometimes you don't want to center a raw number, but rather a visual indicator of that number's performance. For instance, instead of showing the number "85," you might want to display a centered green circle to indicate a good score. This is where conditional formatting with icons comes in handy.

This method has a key benefit: it adds a visual cue while keeping the original numerical data intact for sorting and calculations.

1. With your table selected, go to the Visualizations pane. Don't go to the formatting tab this time. Instead, right-click the field you want to format in the 'Columns' build shelf and navigate to: Conditional formatting > Icons.
2. Expand Cell elements in the Format pane. From the 'Series' dropdown, select the numeric column (e.g., Customer Satisfaction).
3. Turn the Icons toggle switch to 'On'. A small fx button (for formula/function) will appear next to it. Click on that.
4. A dialogue box will open where you can define the rules for your icons. You can set them based on value ranges. For example:
5. Click 'OK'. Now, instead of numbers, you will see expressive, centered icons that are easier to interpret at a glance.

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 3: Advanced Centering using DAX Measures

What if you want total control? Maybe you want to display centered text like "High," "Medium," or "Low" instead of numbers or icons. For this level of customization, we need to create a DAX (Data Analysis Expressions) measure.

This approach involves creating a new column whose output is text. Because it's text, Power BI's default alignment for it is to the left, but we can easily override this using the first method we discussed.

Creating the DAX Measure

Let's create a measure that evaluates sales figures and returns a text-based status.

1. On the 'Home' or 'Modeling' ribbon in Power BI Desktop, click on New Measure.
2. In the formula bar, enter the following DAX formula. This formula uses the SWITCH function to check the sales value and return a corresponding text label.

Performance Status = 
SWITCH(
    TRUE(),
    'Sales'[Total Sales] > 10000, "High",
    'Sales'[Total Sales] > 5000, "Medium",
    "Low"
)

This checks if 'Total Sales' is over 10,000, if so, it returns "High". If not, it checks if it's over 5,000 and returns "Medium". If neither is true, it defaults to "Low".

1. Once you've written your formula, hit Enter and add this new "Performance Status" measure to your table visual.

Centering Your New DAX-driven Column

You’ll notice that your new column is left-aligned by default. Now you can circle back to Method 1:

1. Select your table.
2. Go to the Format your visual pane.
3. Go to Specific column.
4. Choose your 'Performance Status' measure from the dropdown.
5. Under Alignment, select 'Center'.

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

A Quick Heads-up on Sorting

A column created this way is text, which means it will sort alphabetically ("High," "Low," "Medium") instead of logically. To fix this, you would need to create a secondary 'Sort Order' column in your data table (assigning "High" = 1, "Medium" = 2, "Low" = 3), and then in the 'Data view,' select your status column and use the 'Sort by Column' tool to sort it by the new numeric order column.

Final Thoughts

As you can see, Power BI offers several ways to center-align your table values, each suited for a different purpose. For simple adjustments, the formatting pane is your fastest option. For quick visual cues, conditional formatting with icons works wonders. And for complete control over custom text-based outputs, a DAX measure provides the flexibility you need.

It can often feel like you have to learn a whole new set of technical skills just to build a simple, clean-looking report. At Graphed, we’ve built a tool to eliminate this friction entirely. Instead of clicking through dense formatting menus and writing formulas, you can simply connect your data sources and ask questions in plain English, like "Show me my top products by units sold this quarter as a table" and get a perfectly formatted, presentation-ready visual in seconds, without ever opening a formatting pane.