Forum Discussion

atpbi10's avatar
atpbi10
Helper I
4 years ago
Solved

Using advanced slicer filtering

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 f...
Need Help
  • johnt75's avatar
    johnt75
    4 years ago

    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.

johnt75's avatar
johnt75
Super User
4 years ago

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.