Creating custom slicer

[Practice_PBI]

I have a column name Vehical, having values as shown.

I need to have a slicer in such a way that it will have two option "All Vehicals" & "Car".

if All Vehical is selected the it will show all the values from the table
and if CAR is selected the it will show the rows having values Maruti, Tata, Kia, Hyunday.

Thank you.

[Anonymous · Accepted solution]

Hi @Practice_PBI ,

Please create a custom slicer first and then try to create a measure to filter the visual in a custom way.

Custom Slicer = {"All Vehical","Car"}

Measure:

Custom Filter = 
VAR _SELECTVALUE = SELECTEDVALUE('Custom Slicer'[Value])
RETURN
SWITCH(_SELECTVALUE,"All Vehical",1,"Car",IF(MAX('Table'[Vehical]) in  {"Maruti", "Tata", "Kia", "Hyunday"},1,0))

Add this measure into visual level filter and set it to show items when value = 1.

Result is as below.

Best Regards,
Rico Zhou

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