Microsoft Certified: Power BI Data Analyst AssociateVisualize and analyze the dataHard
A data analyst is creating a Power BI dashboard to monitor website traffic. The dashboard includes a line chart showing daily page views and a card displaying the total unique visitors. To make the dashboard more dynamic and interactive, the analyst wants to allow users to switch between viewing 'Page Views' and 'Unique Visitors' on the line chart without having to change the underlying data model or create two separate charts. Which Power BI feature should be used?
- ABookmarks
- BSync Slicers
- CField Parameters
- DWhat-if Parameters
Show answer & explanationAnswer & explanation
Correct answer: C. Field Parameters
Field parameters allow users to dynamically change the measures or dimensions being analyzed in a visual by selecting from a list of fields. This is perfect for the scenario where a user wants to switch between different measures (Page Views vs. Unique Visitors) on the same chart without modifying the report design.
Why the other options are wrong
- A. Bookmarks save the state of a report page, including visible visuals and filters, but would require creating two separate bookmarks (one for each measure) and don't offer a direct dynamic field selection within a single visual.
- B. Sync Slicers ensures that slicers filter across multiple pages, but it doesn't allow for dynamically changing the fields displayed in a visual.
- D. What-if parameters are used to test hypothetical scenarios by changing a single numeric value, not for switching between different measures or dimensions in a visual.
Power BI Field Parameters
A Power BI feature that allows report users to dynamically change the measures or dimensions used in a visual by making selections from a slicer, offering greater interactivity and flexibility.
- Creates a slicer for dynamic field selection.
- Can switch between measures or dimensions.
- Enhances report interactivity without needing multiple visuals.
Memory trick: Parameterize your fields, swap dimensions and measures, interactive reports, bring all the pleasures.