Forum Discussion

Practice_PBI's avatar
Practice_PBI
Regular Visitor
1 year ago
Solved

Creating custom slicer

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.

Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    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.

     

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    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.