How to Show Data Values in Power BI Graph

Want to make your Power BI charts easier to read at a glance? Adding data values directly onto your graphs is one of the simplest and most effective ways to improve clarity. This article will show you exactly how to enable, customize, and even add conditional logic to your data labels to make your reports more insightful and professional.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Why Show Data Values on Your Graphs?

Before diving into the "how," let's quickly cover the "why." Displaying data values, often called data labels, directly on your chart isn't just about aesthetics, it’s about communication. In a world where people scan reports in seconds, visible values make your data instantly digestible.

• Immediate Clarity: Viewers can see the exact figure for a bar, column, or line point without having to hover their mouse or trace a line back to an axis. It removes any guesswork.
• Enhanced Precision: When two bars on a chart are very close in height, it can be difficult to tell the exact difference. Data labels make the distinction clear and precise.
• Better Storytelling: By making key numbers pop, you guide your audience’s attention to the most important parts of the data. This helps you build a more compelling narrative around your insights.
• Reduced Clutter: For very simple charts, data labels can sometimes allow you to remove an axis altogether, leading to a cleaner, more minimalist design.

In short, data labels transform a visual from a general representation into a precise, informative graphic.

The Quick & Easy Way: Turning On Data Labels

Power BI makes adding basic data labels incredibly straightforward. It's a simple toggle that almost instantly adds value to any chart. Let's walk through it using a standard bar chart as an example.

Imagine you have a simple column chart showing 'Total Sales by Product Category'. Here's how to display the sales figures on each column.

Step 1: Select Your Visual

First, click on the chart in your Power BI report canvas. This will select the visual and bring up the visualization-specific panes on the right-hand side of the screen.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Step 2: Navigate to the 'Format visual' Pane

Once your chart is selected, look to the right for the 'Visualizations' pane. You will see three icons at the top: 'Build visual' (a small bar chart icon), 'Format visual' (a paintbrush icon), and 'Analytics' (a magnifying glass icon). Click on the Format visual icon.

Step 3: Enable 'Data labels'

In the 'Format visual' tab, you'll see a list of formatting options like 'Y-axis,' 'X-axis,' 'Legend,' etc. Scroll down until you find Data labels. Simply click the toggle switch to turn it from 'Off' to 'On'.

That's it! The exact numerical values will immediately appear on your chart. But this is just the beginning, the real power comes from customizing these labels.

Customizing Your Data Labels for Maximum Impact

A default data label is good, but a well-formatted label is great. Power BI gives you granular control over almost every aspect of your labels' appearance, helping you integrate them perfectly into your report's design.

After enabling 'Data labels,' click the small arrow next to the toggle to expand the customization options.

Position and Orientation

The first thing you might want to adjust is where the label appears on the visual component.

• Position: This setting controls the label's placement. For a column chart, the options typically include 'Auto,' 'Outside end,' 'Inside end,' 'Inside center,' and 'Inside base.' 'Outside end' is often the cleanest for positive values. For a line chart, you'll see options like 'Under' or 'Above' the line. Play around to see which one works best for your specific chart type.
• Orientation: You can change the label from 'Horizontal' to 'Vertical.' Vertical orientation can be useful for long, narrow column charts where horizontal labels might overlap.

Formatting the Text (Values)

Expand the Values section to control the look of the text itself. This is crucial for ensuring readability.

• Font: Choose a font family, size, and style (bold, italic, underline) that aligns with your report's branding.
• Color: This is a key setting. Best Practice: Choose a color that provides high contrast with the bar/column/line color. If you have dark blue bars, a light gray or white label will be much easier to read than a black one.
• Display units: Are you working with large numbers like 2,345,678? Instead of cluttering your chart, change the 'Display units' from 'Auto' to 'Thousands (K),' 'Millions (M),' or 'Billions (B).' Power BI will automatically convert the number (e.g., $2.3M). You can also control the Value decimal places if you need more or less precision.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Adding a Background

If your labels are hard to read because the chart has a busy or varied-color background, you can add a background color to the label itself.

• Toggle Background to 'On.'
• Choose a Color for the background shape that appears behind your value.
• Adjust the Transparency slider. A semi-transparent background (e.g., 20-40% transparency) can help the number stand out without creating a harsh, boxy look.

Going Pro: Using Conditional Formatting on Data Labels

Here's where things get really fun. You can make your data labels dynamic by changing their color based on their value. This is an advanced technique for drawing immediate attention to performance - good or bad.

Let's say you want sales figures above $500,000 to be green and those below to be red.

Step 1: Find the Conditional Formatting Option

Go to your 'Data labels' settings and expand the 'Values' section. Next to the Color option, you will see a small '<em>fx</em>' icon. This is the conditional formatting button. Click it.

Step 2: Set Up Your Rules

A new window will pop up. This is where you'll define the logic.

1. Format style: Make sure this is set to 'Rules.'
2. What field should we base this on?: Select the data field you're measuring, such as 'Sum of Sales.'
3. Create the Rules: Now you create your conditions.

Step 3: Apply the Formatting

Click 'OK.' Instantly, your data labels will change color based on the rules you just set. Bars representing sales over your target are now highlighted with green labels, drawing immediate attention to your high-performing categories.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Bonus Tip: Displaying Total Labels on Stacked Charts

Stacked bar and column charts have a unique labeling feature. By default, 'Data labels' will show the value for each segment within a bar. But what if you also wanted to see the total sum for the entire bar?

Power BI has a separate option for this. In the 'Format visual' pane, scroll down past 'Data labels' and you will find a toggle for Total labels. Turn this on to display the sum of all segments at the top of each bar. You can then customize the total labels with the same formatting options (font, color, display units) as regular data labels.

Common Pitfalls and Best Practices

While data labels are powerful, they can be misused. Keep these best practices in mind to ensure your reports remain clean and effective.

• Avoid Overcrowding: If you have a line chart with hundreds of data points, turning on labels for every point will create an unreadable mess called "chart noise." In such cases, it's better to rely on tooltips (which appear on hover) or only label significant peaks and valleys.
• Prioritize Readability: The whole point of a label is to be read. Always check that the color contrast, font size, and positioning make the values easy to see. Don't sacrifice readability for style.
• Maintain Consistency: As you build a multi-page report, keep your label formatting consistent. Use the same font size, color, and display units for similar charts to give your report a polished, professional feel.
• Question the Necessity: Before adding labels, ask yourself if they are truly adding value or just restating the obvious. If the y-axis and gridlines already make the values clear, you may not need labels, especially on very busy dashboards.

Final Thoughts

Adding and customizing data labels in Power BI is a fundamental skill that elevates your reports from simple charts to powerful communication tools. By thoughtfully applying positions, formatting, and conditional logic, you guide your audience's focus, tell a clearer data story, and make your insights impossible to ignore.

While mastering Power BI is a valuable skill, sometimes you just need an answer quickly, without digging through formatting panes and menus. We built Graphed to create a faster path from data to insight. Instead of manually tweaking labels, you can simply ask a question like "Show me a bar chart of sales by category, with sales over $500k in green," and Graphed builds the visualization for you, instantly. It lets you focus on the 'what' and 'why' of your data, automating the 'how'.