Question

You are designing a sales report where business users want to change the category on a bar chart's axis between Product Category, Region, and Salesperson without editing the report. They also want a slicer that lets them pick which of these dimensions to display, and the change must apply to a single visual. What is the most appropriate native Power BI Desktop feature to implement this?

Accepted Answer

Create a field parameter that includes the three dimension fields, which automatically generates a slicer bound to the visual's axis.

Answer

Build three separate bar charts and use a bookmark navigator to toggle between them.

Answer

Enable 'Personalize this visual' so consumers can swap fields on the axis in the Power BI service.

Answer

Create a calculation group with three calculation items, one for each dimension, and place it in a slicer.