In a Power BI model with multiple dimensions, which feature allows end users to switch the axis category for a single visual among ProductCategory, Year, and CustomerCity with minimal effort?

In a Power BI model with multiple dimensions, which feature allows end users to switch the axis category for a single visual among ProductCategory, Year, and CustomerCity with minimal effort?

• A. Fields parameter
• B. Pivot table slicer
• C. Calculated table switch
• D. Column-level security

Answer: (A)

Fields parameter lets you switch the axis field of a single visual by providing a parameter that contains multiple fields, such as ProductCategory, Year, and CustomerCity. Create the parameter with those fields and bind a slicer to it, then configure the visual’s axis to use the parameter. When the user selects a different field, the axis updates accordingly in the same chart, with no need to create additional visuals or write new measures. This gives a minimal-effort, flexible experience for exploring different dimensions. The other options don’t offer this dynamic axis switching capability: a pivot table slicer isn’t a standard feature for this purpose, a calculated table switch isn’t a typical Power BI mechanism for axis changes, and column-level security controls access rather than visual configuration.

Fields parameter lets you switch the axis field of a single visual by providing a parameter that contains multiple fields, such as ProductCategory, Year, and CustomerCity. Create the parameter with those fields and bind a slicer to it, then configure the visual’s axis to use the parameter. When the user selects a different field, the axis updates accordingly in the same chart, with no need to create additional visuals or write new measures. This gives a minimal-effort, flexible experience for exploring different dimensions. The other options don’t offer this dynamic axis switching capability: a pivot table slicer isn’t a standard feature for this purpose, a calculated table switch isn’t a typical Power BI mechanism for axis changes, and column-level security controls access rather than visual configuration.