Dashboard tiles and pinning in Power BI - Practice Problems & Coding Challenges

Challenge - 5 Problems

🧠 Conceptual

intermediate

Understanding Dashboard Tile Types

Which of the following tile types in Power BI dashboards can display live data that updates automatically without manual refresh?

A Image tile

B Web content tile

C Report tile pinned from a live report page

D Text box tile

💡 Hint

Think about which tiles connect directly to data sources and update dynamically.

Report tiles pinned from live report pages show live data and update automatically. Image, web content, and text box tiles do not update live data automatically.

❓ dax_lod_result

intermediate

Pinning a Measure to Dashboard

You have a measure Total Sales = SUM(Sales[Amount]) in your Power BI report. You pin a card visual showing this measure to a dashboard. If the underlying data updates and you refresh the dataset, what will the card tile on the dashboard show?

Power BI

Total Sales = SUM(Sales[Amount])

A The updated total sales value reflecting the latest data

B The total sales value at the time of pinning, never updates

C The average sales value instead of total

D An error message because measures cannot be pinned

💡 Hint

Consider how pinned report visuals behave when the dataset refreshes.

Card tiles pinned from report visuals show updated values after dataset refresh because they are linked to the report's live data.

❓ visualization

advanced

Best Practice for Dashboard Tile Layout

You want to create a Power BI dashboard that is easy to read on both desktop and mobile devices. Which layout approach for dashboard tiles is best?

A Use a grid layout with consistent tile sizes and logical grouping

B Arrange tiles in a single column to fit mobile screens

C Place all tiles randomly to fill space and show maximum info

D Use very large tiles that require horizontal scrolling

💡 Hint

Think about readability and ease of navigation on different devices.

A grid layout with consistent tile sizes and logical grouping improves readability and navigation on all devices, including mobile and desktop.

🔧 Formula Fix

advanced

Troubleshooting a Pinned Tile Not Updating

You pinned a report visual to a dashboard. After refreshing the dataset, the dashboard tile still shows old data. What is the most likely cause?

A The dataset refresh failed and did not update data

B The report visual was pinned as an image tile instead of live tile

C The dashboard tile is a snapshot and does not update automatically

D The dashboard has a filter applied that blocks new data

💡 Hint

Consider how different tile types behave after pinning.

If the visual was pinned as an image tile, it is a static snapshot and will not update even after dataset refresh.

🎯 Scenario

expert

Designing a Dashboard with Multiple Data Sources

You need to create a Power BI dashboard that combines tiles pinned from reports using different datasets. What is a key limitation you must consider when pinning tiles from multiple datasets to one dashboard?

A You cannot pin tiles from more than two datasets to the same dashboard

B Tiles from different datasets will always show the same data

C Tiles from different datasets cannot be refreshed automatically together

D Tiles from different datasets cannot be filtered together on the dashboard

💡 Hint

Think about cross-filtering and interaction between tiles from different data sources.

Tiles pinned from different datasets cannot be cross-filtered or interact with each other on the dashboard because they come from separate data models.

Practice

1. What is the main purpose of a dashboard tile in Power BI?

easy

A. To display a visual or report element on a dashboard for quick insights

B. To create new data tables in Power BI

C. To write DAX formulas for calculations

D. To export data to Excel

Solution

1. Step 1: Understand what dashboard tiles do

   Dashboard tiles are snapshots of visuals pinned to a dashboard for quick viewing.

2. Step 2: Identify the correct purpose

   Tiles show visuals or report elements, not data creation or exporting.

3. Final Answer:

   To display a visual or report element on a dashboard for quick insights -> Option A

4. Quick Check:

   Dashboard tile = visual snapshot [OK]

Hint: Tiles show visuals on dashboards, not data or formulas [OK]

Common Mistakes:

• Confusing tiles with data tables
• Thinking tiles create calculations
• Assuming tiles export data

2. Which of the following is the correct way to pin a visual to a dashboard in Power BI?

easy

A. Drag the visual directly onto the dashboard canvas

B. Right-click the visual and select 'Pin to dashboard'

C. Click the pin icon on the visual and choose the dashboard

D. Export the visual and upload it to the dashboard

Solution

1. Step 1: Recall the pinning method

   Power BI shows a pin icon on visuals to pin them to dashboards.

2. Step 2: Identify the correct action

   Clicking the pin icon and selecting the dashboard is the standard method.

3. Final Answer:

   Click the pin icon on the visual and choose the dashboard -> Option C

4. Quick Check:

   Pin icon click = pin visual [OK]

Hint: Look for the pin icon on visuals to pin them [OK]

Common Mistakes:

• Trying to drag visuals onto dashboards
• Right-click menu does not have pin option
• Exporting visuals is unrelated to pinning

3. Consider a dashboard tile pinned from a report visual. If the underlying data changes, what happens to the tile?

medium

A. The tile remains static and does not update

B. The tile updates automatically to reflect the new data

C. The tile deletes itself and must be pinned again

D. The tile shows an error until refreshed manually

Solution

1. Step 1: Understand tile behavior with data changes

   Tiles pinned from report visuals update automatically when data refreshes.

2. Step 2: Confirm automatic update

   This ensures dashboards show current insights without manual action.

3. Final Answer:

   The tile updates automatically to reflect the new data -> Option B

4. Quick Check:

   Tiles auto-update with data changes [OK]

Hint: Tiles refresh automatically with data updates [OK]

Common Mistakes:

• Thinking tiles stay static after pinning
• Assuming manual refresh is needed
• Believing tiles delete on data change

4. You pinned a report page to a dashboard, but the tile shows a blank or error message. What is the most likely cause?

medium

A. The report page was deleted or renamed after pinning

B. The dashboard has too many tiles already

C. You did not refresh the browser after pinning

D. The tile size is too small to display content

Solution

1. Step 1: Identify reasons for blank/error tiles

   If the source report page is deleted or renamed, the tile loses its reference.

2. Step 2: Rule out other causes

   Tile count, browser refresh, or size usually do not cause blank tiles.

3. Final Answer:

   The report page was deleted or renamed after pinning -> Option A

4. Quick Check:

   Missing source page = blank tile [OK]

Hint: Check if the pinned report page still exists [OK]

Common Mistakes:

• Blaming dashboard tile limits
• Forgetting to check report page status
• Assuming browser refresh fixes errors

5. You want to create a dashboard tile that always shows the total sales for the current month, updating automatically. Which approach should you use?

hard

A. Create a text box tile and manually update sales each month

B. Pin a static image of the sales number from last month

C. Export sales data to Excel and upload it as a tile

D. Pin a report visual with a measure filtering sales by current month

Solution

1. Step 1: Identify dynamic tile requirements

   The tile must update automatically with current month sales data.

2. Step 2: Choose the correct pinning method

   Pinning a report visual with a measure filtered by current month ensures automatic updates.

3. Step 3: Exclude static or manual options

   Static images, manual text boxes, or Excel uploads do not update automatically.

4. Final Answer:

   Pin a report visual with a measure filtering sales by current month -> Option D

5. Quick Check:

   Dynamic measure + pin visual = auto-updating tile [OK]

Hint: Use a measure filtered by current month and pin its visual [OK]

Common Mistakes:

• Using static images or manual text boxes
• Uploading Excel files instead of visuals
• Not applying date filters in measures