Question

You publish a sales report to a Power BI workspace. Business users have asked whether they can switch the measure shown in a bar chart from 'Total Sales' to 'Total Profit' themselves, without editing the report or asking you to create additional versions. You want to enable this while keeping the published report definition unchanged. What should you do?

Accepted Answer

Turn on the 'Personalize visuals' setting for the report so consumers can modify fields and aggregations in reading view.

Answer

Create a bookmark for each measure and add a button navigator so users can toggle between saved views.

Answer

Add a field parameter that lets users select the measure from a slicer on the report page.

Answer

Enable edit permissions on the workspace so consumers can open the report in editing mode and change the visual.