Using advanced slicer filtering

[atpbi10]

Here is my data:

Column A	Column B
Car 1	Light Green
Car 2	Dark Green
Car 3	Greenish
Car 4	Azure
Car 5	Other
Car 6	Blue

I would like to create a slicer that can filter out different Green cars or different Blue cars for example.

Is there a way in powrebi to create custom filters on a slicer? I tried creating a measure but it doesnt seem to work on a slicer...

Something in this way

IF Column B = "Azure" or Column B ="Blue" THEN "Blue" (so on the slicer I have Blue option that will filter based on the conditions)

IF Column B="Light Green" or Columnb ="Greenish" .... THEN "Green" (so on the slicer I have green option that will filter based on provided conditions.)

[johnt75 · Accepted solution]

You could create a calculated column as

Colour = SWITCH( TRUE(),
'Table'[Column B] IN { "Azure", "Blue" }, "Blue",
'Table'[Column B] IN { "Green", "Greenish" }, "Green"
)

and then use the new column for slicing and dicing.