Question

You are building a Power BI report on a Fabric semantic model. Business users want a single bar chart where they can interactively switch the axis between Product Category, Region, and Sales Rep without you creating three separate visuals or bookmarks. The switch should be a slicer that changes which dimension column groups the measure. Which semantic model feature should you implement to meet this requirement with the least maintenance?

Accepted Answer

Create a field parameter that includes the three dimension columns and place it on the visual axis and in a slicer.

Answer

Create a calculation group with three calculation items, one per dimension.

Answer

Build a many-to-many bridge table linking the three dimensions.

Answer

Add three separate measures using SELECTEDVALUE and toggle them with bookmarks.