Change measures using slicers

This short guide explains how you can use slicers to select different measures. For example how to use slicers to switch between a percentage of total, YTD or actual vs realisation measure.

Create the measure names in a table

Firstly you’ll need a table with the measure names. There are multiple ways to go about it. You could load it from en external source, create a table and enter values manually or create a table using DAX. This mainly depends on your preference, but as long as it is a single column containing the measure names, you are good to go. After you have created the names, you can create a slicer and add in the column.

Create the Dynamic Measure

Secondly, create a measure that responds to the selected measure name in the slicer.

Measure Selection =

SWITCH( TRUE(),    VALUES('Measure Dimensions'[Measure]) = "First measure name", [First measure],    

VALUES('Measure Dimensions'[Measure]) = " Second measure name ", [Second measure],    

VALUES('Measure Dimensions'[Measure]) = " Third measure name ", [Third measure],    BLANK())

2. (Optional)Capture the Value selected in the Slicer

A nice feature is to display whatever the user selected. Use the following DAX in a card visual to achive this.

User Selection = SELECTEDVALUE('Slicer Table'[Value])

Leave a Comment