You are editing a Power BI Desktop report that contains five pages: Overview, Regional, Product, Margin, and Forecast. A Date hierarchy slicer exists on the Overview page. Business users ask that whatever Date range they pick in the slicer should automatically filter visuals on the Regional and Product pages, but the slicer itself must not be displayed on those pages. The Margin and Forecast pages must remain unaffected. Which feature should you use to implement this requirement?
Open the Sync slicers pane, tick the Sync boxes for the Regional and Product pages, and clear their Visible boxes.
Enable "Filter on all pages" for the slicer in its Format pane.
Duplicate the slicer onto the Regional and Product pages and use Edit interactions to hide its effect on the other pages.
Add the Date field as a report-level filter, lock the filter, and remove the slicer from the canvas.
The Sync slicers pane lets you decide, page by page, whether a slicer should filter a page (Sync column) and whether it should be shown there (Visible column). By selecting Sync for the Regional and Product pages while clearing their Visible check boxes, the Date selections made on the Overview page filter those pages even though the slicer is hidden. A report-level filter would affect all pages, Edit interactions cannot extend a slicer's scope across pages, and there is no "Filter on all pages" option in the slicer's Format pane.
Ask Bash
Bash is our AI bot, trained to help you pass your exam. AI Generated Content may display inaccurate information, always double-check anything important.
What is the role of the Sync slicers pane in Power BI?
Open an interactive chat with Bash
How does a slicer differ from a report-level filter?
Open an interactive chat with Bash
Can Edit interactions extend the scope of a slicer across pages?
Open an interactive chat with Bash
Microsoft Power BI Data Analyst
Visualize and Analyze the Data
Your Score:
Report Issue
Bash, the Crucial Exams Chat Bot
AI Bot
Loading...
Loading...
Loading...
Pass with Confidence.
IT & Cybersecurity Package
You have hit the limits of our free tier, become a Premium Member today for unlimited access.
Military, Healthcare worker, Gov. employee or Teacher? See if you qualify for a Community Discount.
Monthly
$19.99
$19.99/mo
Billed monthly, Cancel any time.
3 Month Pass
$44.99
$14.99/mo
One time purchase of $44.99, Does not auto-renew.
MOST POPULAR
Annual Pass
$119.99
$9.99/mo
One time purchase of $119.99, Does not auto-renew.
BEST DEAL
Lifetime Pass
$189.99
One time purchase, Good for life.
What You Get
All IT & Cybersecurity Package plans include the following perks and exams .