Sync slicers across pages in Power BI - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to create a slicer that filters data by year.

Power BI

Slicer = CALCULATE(VALUES('Date'[[1]]))

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

AYear

BQuarter

CDay

DMonth

Attempts:

3 left

💡 Hint

Common Mistakes

Choosing a less common time period like Day or Month which may not sync well.

Using a column that is not part of the date table.

The slicer should filter by Year to sync across pages effectively.

2fill in blank

medium

Complete the step to enable slicer syncing across pages in Power BI.

Power BI

Go to the View tab and open the [1] pane to manage slicer syncing.

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

ASelection

BFilters

CBookmarks

DSync slicers

Attempts:

3 left

💡 Hint

Common Mistakes

Confusing Sync slicers with Filters or Bookmarks panes.

Not opening the correct pane to manage slicer syncing.

The Sync slicers pane allows you to control which slicers sync across report pages.

3fill in blank

hard

Fix the error in the DAX measure to respect slicer sync across pages.

Power BI

Total Sales = CALCULATE(SUM(Sales[Amount]), ALL([1]))

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

ADate

BSales

CProduct

DCustomer

Attempts:

3 left

💡 Hint

Common Mistakes

Removing ALL from the wrong table.

Not understanding how ALL affects slicer filters.

Using ALL(Date) removes filters from the Date table, which breaks slicer sync. To respect slicers, remove ALL or use FILTER instead.

4fill in blank

hard

Fill both blanks to create a slicer that syncs and filters only selected pages.

Power BI

In the Sync slicers pane, check [1] to sync the slicer and [2] to make it visible on the page.

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

ASync

BHide

CVisible

DLock

Attempts:

3 left

💡 Hint

Common Mistakes

Confusing 'Hide' with 'Visible'.

Not checking 'Sync' to enable syncing.

Checking Sync syncs the slicer across pages, and Visible controls if the slicer shows on that page.

5fill in blank

hard

Fill all three blanks to write a DAX measure that respects synced slicers and calculates sales for selected years.

Power BI

Sales Selected Years = CALCULATE(SUM(Sales[Amount]), FILTER(ALL('Date'), 'Date'[[1]] IN VALUES('Date'[[2]]) && 'Date'[[3]] <> BLANK()))

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

AYear

CMonth

DDate

Attempts:

3 left

💡 Hint

Common Mistakes

Using Month instead of Year for the slicer filter.

Not excluding blank dates which can cause incorrect totals.

The measure filters the Date table by Year using the slicer values and excludes blank dates to respect slicer sync.