You are designing a Power BI report that contains several pages. On one page, users must be able to filter the data by Year by using a slicer. At the same time, every visual on that page must always display only the Product Category value "Beverages", and users must not be able to remove or modify that restriction. The filter must not affect visuals on other report pages. Which approach should you use to meet the requirements?
Add a locked page-level filter for Product Category equal to "Beverages".
Add a hidden, locked report-level filter for Product Category equal to "Beverages".
Add a locked visual-level filter on Product Category to every visual on the page.
Create a slicer for Product Category on the page and disable interactions between the slicer and the other visuals.
A page-level filter applies only to the selected report page, so it does not affect visuals on other pages. When you lock a filter in the Filters pane, it remains active but cannot be changed or removed by report consumers. Applying a locked page-level filter for Product Category = "Beverages" guarantees that all visuals on that page always show Beverages while still allowing the Year slicer to be interactive.
A locked visual-level filter would require configuring every visual individually and would not be easier to maintain. A report-level filter would force the restriction across the entire report, not just the one page. A slicer for Product Category could be cleared by users, even if you disabled its interactions with other visuals, so it would not enforce the requirement.
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 a page-level filter in Power BI?
Open an interactive chat with Bash
How is a locked filter different from an unlocked filter in Power BI?
Open an interactive chat with Bash
Why not use a report-level filter for this scenario?
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 .