How to Add Data Labels in Power BI
- Sophie Ricci
- Views : 28,543
Table of Contents
Data labels are small but mighty. They sit right on top of your bars, lines, and pie slices — turning a chart that forces readers to guess into one that tells a story at a glance.
Yet most Power BI users skip them entirely. They build a chart, publish the report, and wonder why stakeholders keep asking follow-up questions about the numbers.
This guide shows you exactly how to add data labels in Power BI, customize them for maximum clarity, and avoid the mistakes that make dashboards harder to read instead of easier.
What Are Data Labels in Power BI
Data labels are the numerical or text values that appear directly on chart elements — bars, lines, data points, slices, or bubbles. Instead of forcing the viewer to trace a value back to an axis, labels surface the number instantly right where the eye already is.
Research consistently shows that readers process labeled charts faster and with higher accuracy. Studies on data visualization effectiveness find that well-labeled visuals reduce cognitive load by up to 40% compared to unlabeled equivalents. And according to MIT research, the human brain can process visual data up to 60,000 times faster than text — meaning that pairing good charts with precise data labels compounds the clarity benefit significantly.
Power BI supports data labels across virtually every visual type: bar charts, column charts, line charts, pie and donut charts, scatter plots, treemaps, funnel visuals, and more.
Why Data Labels Matter More Than You Think
Before jumping into the how-to, it is worth understanding the stakes.
65% of people are visual learners. When your report lands in front of a decision-maker, they are not reading every number in a table — they are scanning charts. Data labels make those charts self-explanatory.
According to a Forrester report, organizations that use data-driven decision-making are 58% more likely to hit their revenue targets. The prerequisite for data-driven decisions is that the data is actually readable. Data labels are a direct lever on that outcome.
Poor data presentation also costs time: professionals spend an average of 9.5 hours per week searching for or reformatting data (IDC). Every dashboard element that requires interpretation adds to that burden. Labels eliminate interpretation.
How to Add Data Labels in Power BI — Step by Step
Enable Data Labels for Any Visual
The process is the same regardless of the chart type. Here is how to turn on data labels:
- Click on your visual in the report canvas to select it.
- Go to the Format pane — the paint roller icon on the right-hand side.
- Look for the “Data labels” toggle (in newer versions of Power BI, this may appear under “Visual” > “Data labels”).
- Toggle it on.
That is it. Power BI will immediately display values on each data point using its default settings.
Quick tip: If you are using Power BI Desktop, make sure you are in the Report view (not Data or Model view) before selecting a visual.
Customize Data Labels — Font, Color, Size, and Position
Default labels are functional, but they are rarely beautiful. Here is how to fine-tune them.
After enabling data labels, expand the Data labels section in the Format pane. You will see options including:
Color Change the font color to ensure contrast against the chart background. For dark bars, use white labels. For light backgrounds, use dark text. Power BI lets you set a single color or apply conditional formatting for dynamic coloring.
Font size and family Power BI defaults to a small font. Bump it up to at least 10–12pt for readability on standard screens. Consistency matters — use the same font family throughout your report.
Display units For large numbers, switch from the raw value to abbreviated display units: thousands (K), millions (M), or billions (B). A label showing “2.4M” is far more scannable than “2,400,000.”
Decimal places Reduce decimal places for cleaner presentation. For most business reports, 0 or 1 decimal place is sufficient unless precision is critical.
Position Depending on chart type, you can control where labels appear: inside the bar, outside the bar, at the top, center, or bottom. For bar and column charts, “Outside end” is typically the cleanest option. For pie and donut charts, labels can appear inside slices or as callouts outside.
Add Data Labels to Specific Chart Types
Bar and Column Charts
Bar charts are where data labels deliver the most immediate value. Enable them using the steps above and set position to “Outside end” for column charts or “Outside end” for horizontal bars. Use abbreviated display units for any values above 10,000.
Line Charts
Line charts with data labels on every point can feel cluttered. A better approach: enable labels selectively. You can use a measure to show labels only on the last data point, or on specific milestones. In Power BI, you can also apply series-level formatting to control which lines display labels.
Pie and Donut Charts
Pie charts support two label styles: values only, or values with category names. For reports where readers may not know all the segment names, use “Category, Value” to make slices self-identifying. If your donut chart has more than five slices, consider switching to a bar chart — label overlap becomes a real problem at scale.
Scatter Charts
Scatter charts support labels based on a field you choose — typically a name or ID. In the Format pane under Data labels, select the field to display. Keep font size small (8–9pt) to avoid overlap when data points cluster.
Treemaps and Funnel Visuals
These visuals automatically label category names. Add values by enabling data labels and selecting your preferred display unit.
Use Conditional Formatting on Data Labels
This is where Power BI’s data label customization becomes genuinely powerful.
You can apply conditional formatting to label colors, making them react to the underlying data. For example:
- Labels turn green when the value is above target
- Labels turn red when the value falls below a threshold
- Labels display in bold or a different color for the highest-performing category
To apply this:
- Expand Data labels in the Format pane.
- Click the fx button next to the Color field.
- Set rules based on field values or use a measure.
This turns static labels into a live performance indicator — no legend required.
Add Data Labels Using a Measure (Advanced)
If you need total control over what labels display — such as showing percentage of total instead of raw values — create a custom measure.
Example: Show percentage of total on a bar chart
Label % of Total =
DIVIDE(SUM(Sales[Revenue]), CALCULATE(SUM(Sales[Revenue]), ALL(Sales)))
Format the measure as a percentage, then drag it into the Tooltips field well. To display it as the label, place it in the Values field and restrict the visual to display only this measure as the label.
This approach is especially useful in reports where context — not just absolute values — is what drives decisions.
Common Data Label Mistakes to Avoid
Overlapping labels Crowded labels are worse than no labels. If your chart has more than 8–10 bars, consider reducing the visual’s date granularity, using a slicer, or switching to a table for detailed breakdowns.
Wrong display units Showing full numbers like “1,345,892” in a bar label is hard to read at a glance. Always match display units to the audience’s frame of reference.
Inconsistent decimal places One label showing “2.3M” and another showing “2.347M” looks sloppy. Lock decimal places across the report for consistency.
Using labels as a substitute for axis labels Labels add detail; they do not replace axes. Keep axis labels in place so viewers can orient themselves before reading individual values.
Ignoring contrast Dark labels on dark bars, or light labels on light backgrounds, are effectively invisible. Always check your labels against the chart’s fill colors.
Data Label Best Practices for Power BI Reports
Following these principles consistently will make your dashboards noticeably more professional:
Match labels to the chart’s purpose. If the chart shows a trend, labels on every point add noise. If the chart shows comparison, labels on bars add essential context.
Use conditional formatting to reduce cognitive load. Color-coded labels let viewers identify patterns without reading every number.
Test on smaller screens. Labels that look fine on a 27-inch monitor may overlap on a laptop. Power BI’s mobile layout view lets you preview and adjust.
Keep it consistent across the report. Uniform font size, color palette, and display units make the entire report feel intentional and trustworthy.
Less is more. Enable labels on the visuals where they add the most value. Not every chart needs them.
According to a Nielsen Norman Group study, users who encounter consistent formatting in dashboards report 35% higher confidence in the data accuracy. Consistency is not just aesthetic — it builds trust.
Power BI Data Labels and Report Performance
One concern that sometimes comes up: do data labels affect report load time?
The answer is: minimally, in most cases. Data labels are rendered client-side after the query returns results, so they add negligible processing overhead for standard visuals. However, in reports with 50+ visuals on a single page or extremely large datasets, every rendering element compounds. In those scenarios, reducing visual count is a more impactful optimization than removing labels.
For reports with DirectQuery connections, performance is almost entirely determined by the underlying query — not the label rendering.
Conclusion
Data labels are one of the simplest improvements you can make to any Power BI dashboard — and one of the highest-leverage ones. A chart with well-formatted labels communicates faster, builds stakeholder trust, and reduces the back-and-forth that slows down decisions.
Start with your highest-traffic reports. Enable labels on bar and column charts first, dial in the formatting, and then roll the approach across your dashboard portfolio. Small adjustments compound into significantly more readable, more actionable reporting.
The goal is a dashboard that answers questions before they are asked. Data labels get you there.
📊 Turn Data Into Booked Meetings
We design complete outbound campaigns — targeting, messaging, and scaling — that convert prospects into pipeline.
7-day Free Trial |No Credit Card Needed.
FAQs
Does a professional LinkedIn photo really make a difference?
Can I show data labels on only some bars in Power BI?
Why are my data labels not showing in Power BI?
Can I change the data label font in Power BI?
We deliver 100–400+ qualified appointments in a year through tailored omnichannel strategies
- blog
- Sales Development
- How to Add Data Labels in Power BI