Title, labels, and legends in Power BI - Dashboard Guide

Dashboard Mode - Title, labels, and legends

Business Question

How can we clearly show monthly sales data with meaningful titles, axis labels, and legends to help users understand the chart easily?

Sample Data

Month	Product	Sales
January	Apples	120
January	Bananas	80
February	Apples	150
February	Bananas	90
March	Apples	130
March	Bananas	100

Dashboard Components

• KPI Card: Total Sales
  Formula: Total Sales = SUM(Sales[Sales])
  Result: 670
• Clustered Column Chart: Monthly Sales by Product
  Details:
  • Title: "Monthly Sales by Product"
  • X-axis label: "Month"
  • Y-axis label: "Sales Amount"
  • Legend: "Product" (shows Apples and Bananas)

Dashboard Layout

+-----------------------------+
|        Total Sales KPI       |
+-----------------------------+
|                             |
|  Monthly Sales by Product    |
|  [Clustered Column Chart]    |
|                             |
+-----------------------------+

Interactivity

A slicer for Month allows users to select one or multiple months. When a month is selected, both the Total Sales KPI and the Clustered Column Chart update to show data only for the selected months.

Self Check

If you add a filter to show only February, what will the Total Sales KPI show? What products appear in the legend of the chart?

Answer: Total Sales KPI will show 240 (150 + 90). The legend will show both Apples and Bananas since both have sales in February.

Key Result

Dashboard shows total sales and monthly sales by product with clear titles, axis labels, and legends.