Dashboard Creation and Tiles
Power BI dashboards provide a compact view of important business information. They help users monitor key performance indicators, compare results, and identify areas that may require attention. In the Power BI service, dashboards can combine tiles pinned from different reports and semantic models.
This lesson explains the difference between reports and dashboards, how to create a dashboard in the Power BI service, how to pin tiles, how to organize dashboard content, and how to test the finished dashboard for usability.
Learning Objectives
- Understand Power BI dashboards and tiles.
- Differentiate dashboards from reports.
- Identify the role of Power BI Desktop and the Power BI service.
- Create a dashboard in the Power BI service.
- Pin report visuals to a dashboard.
- Arrange and resize dashboard tiles.
- Configure useful dashboard interactions and links.
- Apply dashboard design and testing best practices.
1. What Is a Power BI Dashboard?
A Power BI dashboard is a single-page canvas in the Power BI service that presents important information using tiles. A tile can display content pinned from a report or other supported sources. Dashboards are useful when users need a quick overview rather than a detailed, multi-page investigation.
For example, a sales manager might use a dashboard to monitor total sales, order count, monthly performance, regional results, and progress against business targets.
Example Dashboard Layout
A dashboard places important indicators and selected visuals on one page so users can review the overall situation quickly.
2. Dashboard vs. Report
Reports and dashboards serve related but different purposes. Reports are commonly used for detailed analysis across one or more pages. Dashboards provide a single-page monitoring view in the Power BI service.
| Feature | Report | Dashboard |
|---|---|---|
| Typical location | Power BI Desktop and the Power BI service | Power BI service |
| Page structure | Can contain multiple report pages | Single dashboard canvas |
| Main purpose | Detailed exploration and analysis | Monitoring important information at a glance |
| Content | Visuals built on the report's data model | Tiles pinned from reports and other supported sources |
| Filtering | Includes report filters and slicers | Dashboard tiles generally link users to more detailed content for exploration |
| Creation workflow | Build and format in Power BI Desktop or the service | Create and arrange in the Power BI service |
3. What Is a Dashboard Tile?
A tile is an individual item displayed on a Power BI dashboard. Tiles can contain pinned report visuals, text, images, video, web content, or other supported dashboard content, depending on the available Power BI features and tenant settings.
| Tile Type | Purpose | Example |
|---|---|---|
| KPI tile | Highlights a key measure. | Total Sales |
| Chart tile | Displays a trend or comparison. | Monthly Sales |
| Table tile | Shows selected detailed information. | Top Products |
| Text tile | Provides a title, explanation, or note. | Quarterly Review |
| Image tile | Displays an image where supported. | Organization logo |
4. Understand the Dashboard Creation Workflow
From Data to Dashboard
5. Prepare a Report for Dashboard Use
A useful dashboard begins with a well-designed report. Select visuals that answer important business questions and display them in a clear, readable format before pinning them.
Preparation Checklist
- Load and clean the required data.
- Build the necessary relationships and measures.
- Create report visuals for the main business metrics.
- Use descriptive titles and suitable number formats.
- Check that the measures return correct results.
- Save the report and publish it to the Power BI service.
- Confirm that the published report is available in the intended workspace.
6. Create a Dashboard in the Power BI Service
After publishing a report, use the Power BI service to create a dashboard in a workspace where you have the required permissions. The exact interface labels can vary as Power BI evolves.
Step-by-Step Instructions
- Sign in to the Power BI service.
- Open the workspace containing your published report.
- Locate the dashboard creation option, such as New dashboard, where available.
- Enter a descriptive dashboard name.
- Create the dashboard.
- Open the report you want to use as the content source.
- Choose a visual to pin, using its pin option where available.
- Select the target dashboard and confirm the pin action.
- Repeat for other visuals that are important to the dashboard.
7. Pin a Report Visual to a Dashboard
Pinning places a selected report visual onto a dashboard as a tile. This allows users to see important information on the dashboard and open the underlying report for further analysis when appropriate.
Pinning Workflow
- Open the published report in the Power BI service.
- Identify the visual you want to add to the dashboard.
- Open the visual's available options.
- Select the pin option if it is available for that visual.
- Choose an existing dashboard or create a new one.
- Confirm the action.
- Open the dashboard and verify that the tile appears.
Report Visual to Dashboard Tile
8. Arrange and Resize Dashboard Tiles
After adding tiles, arrange them so the most important information appears first. Dashboard tiles can generally be moved and resized in the Power BI service, subject to the current interface and permissions.
Layout Guidelines
- Place the most important KPIs near the top.
- Group related tiles together.
- Use larger tiles for important trends or comparisons.
- Keep supporting information in secondary positions.
- Avoid excessive empty space and unnecessary tile duplication.
- Use consistent spacing to make the dashboard easier to scan.
9. Understand Tile Behavior and Data Updates
Dashboard tiles and their source reports are related, but they are not identical experiences. A tile presents selected content on the dashboard, while opening the source report provides the report's full interactive analysis.
| Consideration | What to Understand |
|---|---|
| Source report | The report provides the full page layout, visual interactions, and report navigation. |
| Dashboard tile | The tile displays selected content on the dashboard canvas. |
| Data refresh | Tile freshness depends on the source, refresh behavior, and Power BI service features. |
| Permissions | Users need appropriate access to view the underlying content. |
| Navigation | Tiles can provide a route back to the related report or source content where supported. |
10. Use Dashboard Tiles for Business Monitoring
Dashboard tiles are most useful when each tile communicates a clear business message. Select metrics that users need to monitor frequently and include enough context to interpret the values correctly.
Example: Sales Executive Dashboard
- Total Sales: Shows sales for the reporting period.
- Total Orders: Tracks order volume.
- Monthly Sales Trend: Shows changes over time.
- Regional Performance: Compares geographic areas.
- Top Products: Highlights products with the highest sales.
- Target Progress: Compares actual performance with targets when target data is available.
11. Common Dashboard Design Mistakes
| Mistake | Why It Is a Problem | Recommended Solution |
|---|---|---|
| Too many tiles | Important metrics become difficult to identify. | Keep only the tiles needed for the dashboard's purpose. |
| Unclear titles | Users cannot determine what a tile represents. | Use descriptive titles and appropriate units. |
| Inconsistent number formats | Values become harder to compare. | Use consistent currency, percentage, and decimal formats. |
| Unrelated tile placement | The dashboard lacks a logical reading order. | Group related information and prioritize important metrics. |
| No path to details | Users may struggle to investigate a result. | Provide access to relevant reports where appropriate. |
| Unverified data freshness | Users may rely on outdated information. | Review refresh status and explain reporting periods clearly. |
12. Dashboard Sharing and Permissions
A dashboard is useful only when its intended audience can access it. Before sharing, confirm that users have the required permissions for the dashboard and its underlying content. Sharing options and licensing requirements depend on the organization's Power BI configuration.
Sharing Checklist
- Confirm that the dashboard is in the correct workspace.
- Verify the intended audience.
- Check access to the dashboard and source reports.
- Review the organization's sharing and licensing requirements.
- Test access with an appropriate user account when possible.
- Confirm that sensitive information is not exposed to unauthorized users.
13. Hands-On Practice
Task 1: Publish a Sales Report
- Create a report containing Total Sales, Total Orders, Monthly Sales, and Sales by Region.
- Check the calculations, titles, and number formats.
- Publish the report to the appropriate Power BI service workspace.
Task 2: Create a Dashboard
- Open the Power BI service and select the appropriate workspace.
- Create a dashboard named Sales Executive Dashboard, where the option is available.
- Open the published sales report.
- Pin the important visuals to the dashboard.
- Verify that each tile appears correctly.
Task 3: Organize Dashboard Tiles
- Place KPI tiles near the top.
- Position the sales trend prominently.
- Place regional and product comparisons together.
- Resize tiles to improve readability.
- Remove unnecessary or duplicate tiles.
Task 4: Validate the Dashboard
- Confirm the reporting period shown by each metric.
- Check the source report for detailed analysis.
- Review data freshness and access permissions.
- Test the dashboard using the intended viewing account where possible.
14. Knowledge Check
Question 1: Where are Power BI dashboards created?
A. Only in Power BI Desktop
B. In the Power BI service
C. Only in Microsoft Word
D. Only in Excel worksheets
Question 2: What is a dashboard tile?
A. An individual item displayed on a dashboard
B. A database relationship
C. A DAX variable
D. A report page tab
Question 3: What is a common way to add a report visual to a dashboard?
A. Pin the visual from the published report when supported
B. Delete the source report
C. Rename the data model
D. Remove the visual's title only
Question 4: What is the main purpose of a dashboard?
A. To provide a concise view of important information
B. To replace every detailed report
C. To remove all data refreshes
D. To create database tables automatically
Question 5: What should be checked before sharing a dashboard?
A. Access permissions and source content availability
B. Only the dashboard background color
C. The number of fonts installed on the computer
D. Whether all tiles have identical sizes
Show Answers
- B — Dashboards are created in the Power BI service.
- A — A tile is an individual item on the dashboard canvas.
- A — Report visuals can be pinned to dashboards where supported.
- A — Dashboards provide a concise monitoring view.
- A — Verify permissions and access to the underlying content.
Summary
Power BI dashboards provide a single-page view of important business information through tiles. Reports support detailed, multi-page analysis, while dashboards help users monitor key metrics and identify results that need further investigation.
A typical workflow is to prepare and validate the data, build a report in Power BI Desktop, publish it to the Power BI service, create a dashboard, and pin selected report visuals as tiles. Arrange the tiles so the most important information is easy to find.
Before sharing, verify data freshness, source report access, permissions, titles, number formats, and tile behavior. A focused dashboard with clear metrics and access to detailed reports can help users monitor performance and make better business decisions.