Question

You maintain an enterprise semantic model that reports financial KPIs. A single measure, [Selected Value], must display as a currency string (for example, "$1,234") when the user selects the "Revenue" KPI and as a percentage (for example, "12.5%") when the user selects the "Margin %" KPI. The KPI selection is driven by a calculation group. You want the number formatting to switch automatically with the selected calculation item without creating separate measures for each format. Which feature should you configure?

Accepted Answer

A dynamic format string on the calculation item, using the SELECTEDMEASURE() and format string expression

Answer

A field parameter that lets users switch between two pre-formatted measures

Answer

A static format string set on the [Selected Value] measure in the model properties

Answer

Conditional formatting rules applied to the visual displaying [Selected Value]