To allow a Power BI bar chart to change its y-axis category using a slicer, which feature should be added?

Prepare for the Fabric Analytics Engineer Associate Test with comprehensive materials. Explore flashcards, multiple choice questions, and detailed explanations. Get ready for your success!

Multiple Choice

To allow a Power BI bar chart to change its y-axis category using a slicer, which feature should be added?

Explanation:
Dynamic field switching in visuals lets a slicer control which field is used for the axis. Field parameters create a single parameter that holds multiple fields you want to toggle between (for example, Category, Subcategory, Region). You place this parameter on a slicer, and set the bar chart’s y-axis to use that parameter. The slicer selection determines which actual field drives the axis, so the category labels on the chart change accordingly. This is exactly what enables the y-axis to switch based on user choice. Drillthrough is about navigating to a different page with context, not changing which field is shown on the axis. WhatIf parameters adjust numeric scenarios, not which axis field is displayed. Calculation groups organize how measures are calculated, not which axis category is selected dynamically.

Dynamic field switching in visuals lets a slicer control which field is used for the axis. Field parameters create a single parameter that holds multiple fields you want to toggle between (for example, Category, Subcategory, Region). You place this parameter on a slicer, and set the bar chart’s y-axis to use that parameter. The slicer selection determines which actual field drives the axis, so the category labels on the chart change accordingly. This is exactly what enables the y-axis to switch based on user choice.

Drillthrough is about navigating to a different page with context, not changing which field is shown on the axis. WhatIf parameters adjust numeric scenarios, not which axis field is displayed. Calculation groups organize how measures are calculated, not which axis category is selected dynamically.

Subscribe

Get the latest from Passetra

You can unsubscribe at any time. Read our privacy policy