Dashboard tiles and pinning in Power BI - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to pin a visual to a dashboard in Power BI.

Power BI

PinVisualToDashboard(visualId, dashboardId, [1])

Drag options to blanks, or click blank then click option'

Anull

Btrue

Cfalse

Dundefined

Attempts:

3 left

💡 Hint

Common Mistakes

Using false or null will not pin the visual.

Leaving the parameter undefined causes an error.

Setting the third parameter to true confirms pinning the visual to the dashboard.

2fill in blank

medium

Complete the code to create a dashboard tile with a title in Power BI.

Power BI

CreateDashboardTile(dashboardId, visualId, { title: [1] })

Drag options to blanks, or click blank then click option'

A'Sales Overview'

Bnull

Ctrue

D123

Attempts:

3 left

💡 Hint

Common Mistakes

Using a number instead of a string for the title.

Using boolean values instead of text.

The title must be a string, so it should be enclosed in quotes like 'Sales Overview'.

3fill in blank

hard

Fix the error in the code to unpin a tile from a dashboard.

Power BI

UnpinTileFromDashboard(dashboardId, [1])

Drag options to blanks, or click blank then click option'

AvisualId

BtileName

CtileId

DdashboardName

Attempts:

3 left

💡 Hint

Common Mistakes

Using tileName instead of tileId causes failure.

Using dashboardName or visualId is incorrect here.

To unpin a tile, you must specify the tileId, which uniquely identifies the tile.

4fill in blank

hard

Fill both blanks to filter a dashboard tile by category and date.

Power BI

ApplyFilterToTile(tileId, { category: [1], date: [2] })

Drag options to blanks, or click blank then click option'

A'Electronics'

B'2024-01-01'

C'Furniture'

D'2023-12-31'

Attempts:

3 left

💡 Hint

Common Mistakes

Using dates without quotes causes errors.

Mixing category and date values.

The category filter should be 'Electronics' and the date filter '2024-01-01' as strings.

5fill in blank

hard

Fill all three blanks to create and pin a dashboard tile with a title and filter.

Power BI

const tile = CreateDashboardTile(dashboardId, visualId, { title: [1], filter: [2] });
PinVisualToDashboard(visualId, dashboardId, [3]);

Drag options to blanks, or click blank then click option'

A'Monthly Sales'

B{ category: 'Books' }

Ctrue

Dfalse

Attempts:

3 left

💡 Hint

Common Mistakes

Using false instead of true for pinning.

Not using an object for the filter.

Missing quotes around the title.

The title is 'Monthly Sales', the filter is an object { category: 'Books' }, and true confirms pinning.

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