Question

A Power BI model contains a [Total Sales] measure and identical measures for cost and profit. Report authors want users to pick which metric appears in a single card and line chart via a slicer, without creating three separate visuals. You need the slicer selection to dynamically swap the displayed measure while keeping the model maintainable. Which approach best meets this requirement?

Accepted Answer

Create a disconnected table listing the metric names, then a measure using SWITCH(SELECTEDVALUE(...)) to return the corresponding calculation.

Answer

Build a bidirectional relationship between the metric table and the fact table so selections filter the measures directly.

Answer

Add three separate line charts and use bookmarks with buttons to toggle visibility of each metric.

Answer

Create a role-playing dimension from the fact table and connect each metric through a USERELATIONSHIP call.