Microsoft Certified: Power BI Data Analyst AssociateVisualize and analyze the dataMedium
A financial analyst is creating a Power BI report to track quarterly expenses across different departments. The analyst wants to enable users to easily switch between viewing expenses by 'Category', 'Vendor', or 'Project' without modifying the report structure. The goal is to dynamically change the dimension used in a bar chart and a table visual based on user selection. Which Power BI feature should the analyst use to achieve this dynamic switching capability?
- ADrill-through pages
- BBookmarks
- CField parameters
- DCalculated tables
Show answer & explanationAnswer & explanation
Correct answer: C. Field parameters
Field parameters allow users to dynamically change the fields (dimensions or measures) used in a visual. This is perfect for scenarios where users need to switch between different ways of slicing or dicing data without altering the report's underlying structure.
Why the other options are wrong
- A. Drill-through pages navigate to a different page with filtered details, not dynamically swap fields within a visual on the same page.
- B. Bookmarks save the current state of a report page, including filters and visual selections, but don't dynamically change fields in a visual.
- D. Calculated tables create new tables in the data model, which is a data modeling technique, not a report interaction feature for dynamic field swapping.
Power BI Field Parameters
Field parameters allow report users to dynamically change the dimensions or measures used in a visual by interacting with a slicer. This provides flexibility in data exploration without requiring multiple visuals or report pages.
- Created from the Modeling tab.
- Generates a slicer that controls fields in visuals.
- Can be used for both dimensions and measures.
Memory trick: To let users choose their view, field parameters are the magic key.