Solved: Choose between measures in a slicer - Page 2

Anonymous · ‎08-01-2017

Hi,

In a table, I have sales in Value, Volume and Units in different columns. In the table and/or chart, I would like to be able to choose if I want to see Value, Volume or Units in a filter of a slicer

Is that possible?

v-shex-msft · ‎08-02-2017

Hi @Anonymous,

You can refer to below steps to achieve your requirement:

1. Create a Selector table as source of slicer.

Selector = UNION(ROW("Type","Amount"),ROW("Type","Value"),ROW("Type","Unit"))

2. Write measure to original table to choose display item based on slicer.

Dynamic Display = 
var selectitem=IF(HASONEVALUE(Selector[Type]),VALUES(Selector[Type]),BLANK())
return
SWITCH(selectitem,"Amount",MAX('Table'[Amount]),"Unit",MAX('Table'[Unit]),"Value",MAX('Table'[Value]),BLANK())

3. Create table visual and slicer.

Result:

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post