Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
atpbi10
Helper I
Helper I

Using advanced slicer filtering

Here is my data:

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

 

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.)

1 ACCEPTED SOLUTION
johnt75
Super User
Super User

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.

View solution in original post

1 REPLY 1
johnt75
Super User
Super User

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.

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.