Creating custom slicer

Practice_PBI — Tue, 04 Feb 2025 10:29:56 GMT

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.

Re: Creating custom slicer

Anonymous — Wed, 05 Feb 2025 05:27:54 GMT

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.

topic Re: Creating custom slicer in Developer

Creating custom slicer

Re: Creating custom slicer