I need to create a filter where i can switch between two colums that contains strings

[Patroxalpbi]

Hi,

I'm trying to create a measure/column that i can use as a filter. 

I would like to have 

- 1 bottom: should be a slicer where i can click LOB or LOB before reclass

- 1 filter: Based on what i select in the bottom the filter should switch between the two columns

Unique identifier	LOB	LOB before reclass
x1	Install	Not install
x2	Install	Install
x3	Install	Install
x4	Not install	Not install
x5	Not install	Not install
x6	Not install	Not install

Thank you

[samratpbi · Accepted solution]

Hi, you may achieve this using Field parameter.

Go to Modeling tab -> New Parameter -> Fields.

On the parameter section, use LOB & LOB before class columns. and keep it default. that will introduce a slicer to select LOB or LOB before class.

Param_FM = {

    ("LOB", NAMEOF('Param'[LOB]), 0),

    ("LOB before reclass", NAMEOF('Param'[LOB before reclass]), 1)

}

now on 2nd slicer, use the Param_FM

I have created one more row col1 & col2 to demonstrate. 

If this helps to resolve your problem then please mark it as solution, Thanks!