Combine 2 indiviual slicers and use the result as a single slicer

[Aishwaryazanpur]

Dear all,

I want to show current and proposed state of the depot, for that,  I am making use of 2  slicers with the following conditions:

1 st slicer: channels in depot (with 0,1,2,3 as options to select from) 2. assigned (short, long, null as options)

conditions

current state  : channels in depot >0 and assigned can be short / long / null (this combination is needed to depict current state)

proposed state : channels in depot =0 and assigned = short /long

Currently, I am using channels in depot and assigned as 2 different slicers can I combine these 2 slicers in to 1 (by caculated column / measure ) as use result as single slicer

[Aishwaryazanpur]

Thank you so much!

[v-xinruzhu-msft · Accepted solution]

Hi @Aishwaryazanpur 

You can create a new table

Table = var a=SELECTCOLUMNS(GENERATESERIES(0,4,1),"num",[Value])
var b={"long","short","null"}
return GENERATE(a,b)

Then create a measure

Measure = var a=FILTER('Table',[num]>0&&[Value] in VALUES('Table'[Value]))
return IF(SELECTEDVALUE('Table'[num])>0&&SELECTEDVALUE('Table'[Value]) in VALUES('Table'[Value]),1,IF(SELECTEDVALUE('Table'[num])=0&&SELECTEDVALUE('Table'[Value]) in {"long","short"},1,0))

Then create a slicer and put the field to the slicer

and put the measure filter to the slicer

Output

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.