Formatting Titles, Labels, Legends, Tooltips, and Axes in Microsoft Power BI

Course: Microsoft Power BI Training

Topic: Formatting Titles, Labels, Legends, Tooltips, and Axes

Course Link: Microsoft Power BI Training – JustAcademy

Demo Link: Register for a Course Demo

JustAcademy Website: Visit JustAcademy

1. Introduction to Formatting in Power BI

Microsoft Power BI is a business intelligence and data visualization platform that helps users transform data into meaningful reports and interactive dashboards. Formatting is an important part of creating professional reports because it improves readability, highlights important information, and helps users understand data quickly.

Formatting titles, labels, legends, tooltips, and axes helps communicate the meaning of a visual clearly. A chart may contain accurate data, but without proper formatting, users might struggle to identify its purpose, interpret values, or compare categories.

For example, a column chart displaying monthly sales becomes easier to understand when it has a descriptive title, readable month labels, a properly formatted currency axis, a clear legend, and useful tooltips.

1.1 Why Formatting Is Important

• Improves report readability and visual consistency.
• Helps users understand the purpose of each chart.
• Makes categories, values, and data series easier to identify.
• Reduces confusion caused by unclear labels or scales.
• Highlights important business metrics and trends.
• Supports accessible and user-friendly report design.
• Creates professional dashboards suitable for business presentations.

1.2 Main Formatting Elements

2. Understanding the Format Visual Pane

The Format visual pane contains settings used to customize the appearance and behavior of Power BI visuals. The available settings depend on the selected visual type and the Power BI editing experience.

2.1 Steps to Open the Format Visual Pane

1. Open Power BI Desktop.
2. Open an existing report or create a new report.
3. Select a chart, table, card, or another visual on the report canvas.
4. Locate the Visualizations pane.
5. Select the Format visual icon, commonly represented by a paintbrush or formatting symbol.
6. Explore the Visual and General tabs where available.
7. Expand the relevant formatting section and adjust the required properties.

2.2 Visual Tab and General Tab

The exact section names and available options may vary by visual, Power BI version, and whether the report is being edited in Power BI Desktop or the Power BI service.

3. Formatting Chart Titles

A chart title communicates the purpose of a visual. A clear title allows users to understand the information without needing to inspect the underlying fields or data model.

3.1 Examples of Effective Titles

3.2 Steps to Format a Title

1. Select the visual you want to format.
2. Open the Format visual pane.
3. Open the General tab and expand Title, if available in the current interface.
4. Turn the title on if it is disabled.
5. Enter a descriptive title in the text field.
6. Choose a suitable font family, font size, color, and style.
7. Set horizontal alignment to left, center, or right.
8. Enable text wrapping when a longer title needs more than one line.
9. Adjust the title background, divider, and spacing if required.

3.3 Important Title Properties

3.4 Adding a Subtitle

A subtitle gives supporting information that may not fit naturally in the main title.

Title: Monthly Revenue Performance

Subtitle: Revenue in Indian rupees for the selected financial year

Use subtitles to explain units, reporting periods, selected business segments, or important assumptions. Avoid repeating the title with different wording.

3.5 Creating Dynamic Titles

Dynamic titles update according to filters, slicers, or other report selections. They can help users understand which period or category is currently being displayed.

For example, create a measure in Power BI using DAX:

Dynamic Sales Title =
"Sales Performance - " &
SELECTEDVALUE(
    'Date'[Year],
    "All Years"
)

To use a measure for a title, select the visual, open the title formatting settings, and use the conditional formatting or expression option (fx) where supported. Choose the appropriate field-value configuration and select the measure.

If a report user selects 2026 in the Year slicer, the title can display “Sales Performance - 2026.” When no single year is selected, it can display “Sales Performance - All Years.”

Important: The example assumes a table named Date with a column named Year. Replace the table and column names to match your data model.

4. Formatting Data Labels

Data labels display information directly on a chart, reducing the need to estimate values from the axis. They are particularly useful when users need to compare individual categories or identify exact values.

4.1 Example of Data Labels

Suppose a chart displays sales for three products:

With data labels enabled, the values appear directly on or near the corresponding bars or columns.

4.2 Steps to Enable Data Labels

1. Select a supported chart visual.
2. Open the Format visual pane.
3. Find the Data labels section under the Visual tab or the equivalent section for that visual.
4. Turn data labels on.
5. Adjust the font size and color.
6. Choose a label position, such as inside, outside, or at an endpoint, when supported.
7. Configure decimal places and display units where available.
8. Review the chart to ensure the labels do not overlap.

4.3 Common Data Label Properties

4.4 Best Practices for Data Labels

• Enable labels when exact values are important to the reader.
• Use a readable font size and adequate contrast.
• Avoid displaying too many labels in dense charts.
• Use consistent number formats across related visuals.
• Consider turning labels off when they overlap or make a chart difficult to read.
• Use tooltips to provide detailed values when permanent labels would create clutter.

5. Formatting Legends

A legend explains what different colors, lines, or other visual encodings represent in a chart. It is especially useful when a chart contains multiple data series.

5.1 Example of a Legend

A line chart showing sales for several regions might use the following legend:

• North – Blue line
• South – Orange line
• East – Green line
• West – Purple line

The legend helps users connect each line with its corresponding region.

5.2 Steps to Format a Legend

1. Select a visual that supports a legend.
2. Open the Format visual pane.
3. Expand the Legend section, usually under the Visual tab.
4. Turn the legend on or off as needed.
5. Set the legend title if a title is useful and supported.
6. Choose a suitable position, such as top, bottom, left, or right.
7. Adjust the font, text size, and text color.
8. Check whether the legend occupies too much space or wraps unnecessarily.

5.3 Legend Formatting Options

5.4 When Should You Hide a Legend?

• When the chart contains only one series and the meaning is already obvious.
• When direct labels clearly identify the data series.
• When the legend takes up too much room on a small visual.
• When removing it improves clarity without removing essential information.

5.5 Legend Best Practices

• Use meaningful category names.
• Keep the same color assigned to a category across related report pages.
• Avoid using many similar colors for different categories.
• Choose a position that does not reduce the chart's useful plotting area unnecessarily.
• Do not rely on color alone when the report needs to be accessible to all users.

6. Understanding and Formatting Tooltips

A tooltip is a small information panel that appears when a user hovers over a data point. It can show additional information without displaying every detail permanently on the chart.

Tooltips are useful for displaying supporting metrics, detailed category names, percentages, dates, profit values, and other contextual information.

6.1 Example of a Tooltip

When a user hovers over a sales column for the Laptop category, a tooltip might display:

• Product: Laptop
• Total Sales: ₹80,000
• Total Profit: ₹12,000
• Units Sold: 40
• Profit Margin: 15%

The chart remains uncluttered while users can inspect the additional details when required.

6.2 Default Tooltips

Power BI provides default tooltips for many visuals. These generally display information associated with the selected data point and the fields or measures used by the visual.

6.3 Adding Fields to a Tooltip

1. Select the visual you want to customize.
2. Locate the Build visual or data field area.
3. Drag the relevant fields or measures into the visual's Tooltips field well when available.
4. Open the report view and hover over the visual's data points.
5. Verify that the expected values appear.
6. Remove unnecessary fields if the tooltip becomes too crowded.

6.4 Formatting Default Tooltips

1. Select the visual.
2. Open the Format visual pane.
3. Locate the Tooltips section. Its position and available options depend on the interface and visual type.
4. Adjust supported text, label, background, color, or transparency settings.
5. Test the tooltip by hovering over several data points.

6.5 Creating Report Page Tooltips

A report page tooltip is a dedicated report page designed to appear when a user hovers over a data point. It can include cards, tables, charts, and measures to provide a richer explanation.

General workflow:

1. Create a new report page.
2. Open the page formatting settings and enable the tooltip page option where available.
3. Configure the page size or canvas type for tooltip use.
4. Add relevant visuals, such as sales, profit, quantity, or a small trend chart.
5. Keep the layout compact and easy to read.
6. Select the original visual that should display the tooltip.
7. Open its tooltip settings and choose the report-page tooltip type.
8. Select the tooltip page from the available list.
9. Test the result by hovering over data points in the original visual.

Report page tooltip support and configuration can vary by visual type and Power BI version. Verify that the selected page is configured correctly and that the intended fields filter the tooltip content.

6.6 Tooltip Best Practices

• Show details that add value beyond what is already visible.
• Use consistent currency, percentage, and date formats.
• Keep report page tooltips compact and relevant.
• Use clear labels rather than unexplained abbreviations.
• Check that the tooltip responds correctly to filters and cross-highlighting.
• Do not make essential information available only through hover interactions if users may access the report on touch devices or with assistive technology.

7. Understanding Chart Axes

Axes provide a reference framework for interpreting data in charts. They help users identify categories, time periods, quantities, and numerical values.

Most Cartesian charts have a horizontal X-axis and a vertical Y-axis. Other visual types, such as pie charts, do not use conventional X- and Y-axes.

7.1 X-Axis

The X-axis is commonly used for categories or time periods.

Example: January, February, March, April, and May.

7.2 Y-Axis

The Y-axis commonly represents a numeric measure such as sales, revenue, profit, quantity, or percentage.

Example: Revenue values ranging from ₹0 to ₹100,000.

7.3 Axis Formatting Properties

8. Formatting the X-Axis

The X-axis is often used to show product names, departments, regions, or dates. Proper formatting prevents category labels from becoming crowded or difficult to read.

8.1 Steps to Format the X-Axis

1. Select a column chart, bar chart, line chart, or another visual with a category axis.
2. Open the Format visual pane.
3. Locate the X-axis or category axis section.
4. Adjust the title and label visibility where supported.
5. Set the label font size and color.
6. Review label density, rotation, or text wrapping options where available.
7. Choose a suitable axis type, such as categorical or continuous, when the visual supports it.
8. Review the chart at its intended report size.

8.2 Example of X-Axis Formatting

Suppose a chart contains 12 monthly sales values. Displaying full date strings may create unnecessary clutter. Short labels such as Jan, Feb, Mar, and Apr can make the chart easier to read when the context is clear.

For long product names, consider a horizontal bar chart, shorter display labels, or a wider visual instead of forcing many labels into a narrow space.

9. Formatting the Y-Axis

The Y-axis often displays numerical values. Its scale, number format, title, and gridlines affect how users interpret the magnitude of the data.

9.1 Steps to Format the Y-Axis

1. Select the chart.
2. Open the Format visual pane.
3. Locate the Y-axis or value axis section.
4. Set a descriptive axis title, such as Total Sales or Profit Margin.
5. Choose the label text size and color.
6. Set the display units to an appropriate value, such as None, Thousands, or Millions, when available.
7. Adjust decimal places and numeric formatting where supported.
8. Set the minimum or maximum range only when appropriate and supported.
9. Review the scale to ensure it communicates the data honestly.

9.2 Display Units Example

The exact displayed notation depends on the visual and formatting settings. Always make the units clear in the axis title, chart title, or labels so that readers do not misinterpret the values.

9.3 Axis Scale Considerations

• Use a suitable range for the business question being answered.
• Be cautious when setting a non-zero baseline for bar or column charts because it can exaggerate differences.
• Use consistent scales when comparing similar charts.
• Do not force a scale that hides important variation.
• Ensure that the axis units match the measure's actual meaning.

10. Formatting Axis Titles and Gridlines

Axis titles explain what the axis measures, while gridlines help users estimate the values represented by data points.

10.1 Good Axis Titles

• Sales Amount (₹)
• Units Sold
• Profit Margin (%)
• Order Date
• Customer Count

10.2 Gridline Formatting

Gridlines can improve readability by helping users compare values against a scale. However, too many dark gridlines can overpower the data.

1. Select a visual that supports gridlines.
2. Open the relevant axis or gridlines formatting section.
3. Turn gridlines on or off as needed.
4. Choose a subtle color and suitable line style where supported.
5. Reduce unnecessary visual noise while keeping important reference lines visible.

11. Formatting Number, Currency, Percentage, and Date Values

Consistent formatting helps users understand values and compare information accurately. Whenever possible, set the correct data type and format in the semantic model or measure, then configure visual-specific display options as needed.

11.1 Currency Formatting

For a sales or revenue measure, display the correct currency symbol and suitable decimal precision.

Total Sales = SUM(Sales[SalesAmount])

If the report uses Indian rupees, format the measure as currency using the appropriate model formatting options. The exact displayed symbol and separators depend on the model locale and formatting configuration.

11.2 Percentage Formatting

Profit Margin =
DIVIDE(
    [Total Profit],
    [Total Sales],
    0
)

Format the measure as a percentage. For example, a ratio of 0.15 should display as 15% when formatted correctly.

11.3 Date Formatting

For time-based charts, use readable date labels. Depending on the business question, labels such as Jan 2026, Q1 2026, or 21 Oct 2026 may be more useful than a long timestamp.

11.4 Formatting Guidelines

12. Using Tooltips and Labels Together

Data labels and tooltips serve related but different purposes. Data labels show selected information directly on the chart, while tooltips provide additional detail when a user interacts with a data point.

Example: A bar chart can show sales totals as labels while the tooltip displays sales, profit, units sold, and profit margin. This provides quick comparisons and deeper detail without crowding the visual.

13. Maintaining Consistency Across Visuals

Professional Power BI reports use consistent formatting throughout the report. A shared visual style makes it easier for users to understand related charts and recognize important information.

13.1 Consistency Guidelines

• Use consistent title sizes and alignment across similar visuals.
• Use the same color for the same business category throughout the report.
• Apply consistent currency, date, and percentage formats.
• Keep axis titles short and descriptive.
• Use a consistent legend position when it improves comparison.
• Keep tooltips focused on relevant business information.
• Use sufficient contrast between text and backgrounds.
• Avoid unnecessary borders, shadows, and decorative elements.

13.2 Using Report Themes

Report themes help standardize colors and other supported formatting properties across a report. They can reduce the need to format each visual individually. Individual visual settings may override theme defaults, so review the final report for consistency.

14. Accessibility and Readability

Accessible formatting makes reports easier to use for a wider audience, including users with visual or cognitive accessibility needs.

• Use readable font sizes for titles, labels, legends, and axes.
• Maintain sufficient contrast between text and its background.
• Do not use color as the only way to communicate a difference.
• Use descriptive visual titles and meaningful axis names.
• Provide useful alt text for visuals where appropriate.
• Do not rely exclusively on hover interactions for essential information.
• Test the report at different screen sizes and zoom levels.
• Avoid excessive labels and long blocks of text inside charts.

15. Common Formatting Problems and Solutions

16. Practical Example: Formatting a Monthly Sales Chart

In this exercise, create a chart that displays monthly sales and apply titles, data labels, a legend where useful, tooltips, and axis formatting.

16.1 Sample Dataset

16.2 Step-by-Step Implementation

1. Import the sample dataset into Power BI Desktop.
2. Confirm that Sales and Profit are numeric columns.
3. Create a clustered column chart.
4. Add Month to the X-axis.
5. Add Sales to the Y-axis or the visual's value field.
6. Add Region to the Legend field if you want to compare regional sales.
7. Set the title to Monthly Sales by Region.
8. Enable data labels if the chart remains readable.
9. Format the value axis using a clear sales unit and currency convention.
10. Adjust the category-axis labels to keep month names legible.
11. Add Profit to the tooltip field well if supported by the selected visual.
12. Choose consistent series colors for North and South.
13. Review the result and check whether any labels or legend entries overlap.

16.3 Expected Result

The report should clearly show monthly sales for the North and South regions. Users should be able to identify the chart's purpose from the title, compare regional values through the legend and series colors, read values from the labels when enabled, and inspect profit details through tooltips.

17. Practical Exercise: Formatting a Profit Analysis Report

Create a report page that helps a sales manager understand profitability by product category.

17.1 Requirements

• Create a chart showing total profit by product category.
• Add a clear title such as Profit by Product Category.
• Enable data labels if they improve readability.
• Format profit as currency.
• Use a legend only if the chart contains multiple series that need identification.
• Add sales and profit margin to the tooltip if relevant.
• Use readable axis labels and suitable display units.
• Apply consistent colors and text formatting.

17.2 Questions to Evaluate Your Report

1. Can a user understand the chart's purpose without additional explanation?
2. Are the axis labels and units clear?
3. Can the user identify the highest-profit category easily?
4. Do the data labels overlap?
5. Does the tooltip provide useful information beyond the visible chart?
6. Are colors and fonts consistent with the rest of the report?

18. Best Practices for Power BI Visual Formatting

• Start with the business question before selecting formatting options.
• Use clear titles that describe the metric and category or time period.
• Use subtitles for context rather than repeating the title.
• Display data labels only when they improve interpretation.
• Keep legends concise and position them where they are easy to scan.
• Use tooltips to provide supporting details without cluttering the chart.
• Use readable axis labels and descriptive axis titles.
• Choose display units that suit the size and purpose of the data.
• Be cautious when changing axis ranges to avoid misleading comparisons.
• Use report themes to maintain consistent visual formatting.
• Test the report in reading mode and at its intended display size.
• Review the report for accessibility, contrast, and legibility.
• Reset an individual formatting section to its defaults if experimentation makes the visual harder to understand.

19. Interview Questions and Answers

Q1. What is formatting in Power BI?

Answer: Formatting is the process of customizing the appearance and presentation of visuals, including titles, labels, legends, tooltips, axes, colors, and backgrounds.

Q2. What is the purpose of a chart title?

Answer: A chart title explains the purpose of the visual and helps users understand what information is being presented.

Q3. What are data labels?

Answer: Data labels display values directly on chart data points, helping users read exact values without estimating them from an axis.

Q4. What is a legend in Power BI?

Answer: A legend identifies the meaning of different colors or series in a visual, such as sales by region or revenue by product category.

Q5. What is a tooltip?

Answer: A tooltip is an information panel that appears when a user hovers over or interacts with a data point. It can display additional fields and measures.

Q6. What is a report page tooltip?

Answer: A report page tooltip is a dedicated report page that can display supporting visuals and measures when a user hovers over a compatible data point.

Q7. What is the difference between the X-axis and Y-axis?

Answer: The X-axis commonly represents categories or time periods, while the Y-axis commonly represents numeric measures such as sales, profit, or quantity.

Q8. How can you make axis labels easier to read?

Answer: Use readable font sizes, reduce label density, shorten labels where appropriate, adjust the visual size, and select a suitable chart orientation.

Q9. Why are display units important?

Answer: Display units help present large values in a compact format, such as thousands or millions, while making the scale easier to interpret.

Q10. What is a dynamic title?

Answer: A dynamic title uses a measure or supported expression to update title text based on filters, slicers, or other report selections.

Q11. When should data labels be disabled?

Answer: Data labels may be disabled when the chart contains too many data points, labels overlap, or the chart becomes visually cluttered.

Q12. Why should axis scales be reviewed carefully?

Answer: Axis scales affect how users perceive differences between values. Unsuitable ranges can exaggerate or hide variations and lead to misleading interpretations.

Q13. What is the benefit of a report theme?

Answer: A report theme helps maintain consistent colors and supported formatting defaults across visuals, reducing repetitive manual formatting.

Q14. Why should tooltips not contain too much information?

Answer: Overloaded tooltips are difficult to scan. They should focus on details that help explain or interpret the selected data point.

Q15. Are all formatting options available for every visual?

Answer: No. Formatting options depend on the visual type, the available fields, the Power BI version, and the editing environment.

20. Quick Revision Checklist

• Understand the Format visual pane and its available tabs.
• Write clear titles and use subtitles when additional context is necessary.
• Enable and customize data labels when they improve readability.
• Use legends to identify meaningful series or categories.
• Use tooltips to display supporting details.
• Format X-axis and Y-axis labels, titles, scales, and units appropriately.
• Apply consistent currency, percentage, numeric, and date formats.
• Use themes and consistent colors across related visuals.
• Check for overlapping labels and crowded legends.
• Review accessibility, contrast, and the accuracy of visual comparisons.

21. Learning Outcomes

After completing this topic, learners should be able to:

• Navigate the Power BI Format visual pane.
• Customize chart titles and subtitles.
• Enable and format data labels.
• Configure legends for multi-series visuals.
• Use default and report page tooltips where supported.
• Format category and value axes.
• Apply appropriate number formats and display units.
• Identify and correct common formatting issues.
• Build more consistent, readable, and professional Power BI reports.

22. Official Learning Resources

• Microsoft Learn: Get Started Formatting Report Visualizations
• Microsoft Learn: Format Pane General Tab Overview
• Microsoft Learn: Customize Titles, Backgrounds, and Legends
• JustAcademy: Microsoft Power BI Training
• JustAcademy: Register for a Course Demo

23. Conclusion

Formatting titles, labels, legends, tooltips, and axes is an essential Power BI skill. These elements help users identify a chart's purpose, interpret values, compare categories, and explore supporting information. Effective formatting combines clarity, consistency, accessibility, and accurate representation of the underlying data.

By practicing these techniques, learners can create reports that are easier to understand, more visually consistent, and more useful for business decision-making.

Explore More: Visit JustAcademy or explore the Microsoft Power BI Training course. You can also register for a course demo.