A developer needs to dynamically change the measure displayed in a visual based on a slicer selection (e.g., toggling between Revenue, Profit, and Units). Which Power BI technique achieves this?

Question

Power BI — Hard

A developer needs to dynamically change the measure displayed in a visual based on a slicer selection (e.g., toggling between Revenue, Profit, and Units). Which Power BI technique achieves this?

Accepted Answer

To dynamically change the measure in a Power BI visual, two approaches are viable. Using a field parameter allows for flexible measure selection, while the SWITCH function with SELECTEDVALUE enables conditional measure selection. Both methods effectively toggle between measures like Revenue, Profit, and Units based on slicer input. This dual approach offers flexibility in report design.