Bypass one category from Slicer Categories

[kkalyanrr]

Hello Team,

I'm trying to locate 3 types of categories on Map, it has multiple filters like suburb, locality..
my requirement is of 3 categories , one category should always visible even though I apply any other filters...
Any idea..

Categories	Latitude	Longitude	Suburb	Locality
Migration Location	-37.8363	144.6595	Tarneit	Tarneit
Migration Location	-37.6383	145.016	Epping North	Epping
Migration Location	-37.6383	145.016	Epping	Epping
Home Suburb Location	-37.8504	144.6064	Wyndham Vale	Wyndham Vale
Home Suburb Location	-37.5922	145.0855	Mernda	Wyndham Vale
Home Suburb Location	-37.407	144.962	Wallan	Wallan
Display	-37.301	144.959	Missing	Missing
Display	-38.1529	145.1954	Missing	Missing
Display	-37.5813	144.9258	Missing	Missing

Scenario 1 :
when I select Tarniet from Suburb , Tarniet should be highlated also all the Displays are also to be shown..
Scenario 2 :
When I select Epping from Locality, Epping should be highlated also all the Displays are also to be shown..

no matter what I select in suburb/locality filters , Displays(Black Bubbles) should be there always on Map... 

[v-jayw-msft · Accepted solution]

Hi @kkalyanrr ,

Create independent slicer tables then create a measure like below:

slicer1 = distinct([suburb])
slicer2 = distinct([locality])

Measure = if(selectedvalue([categories]) = "Display"||selectedvalue([suburb]) in values(slicer1[suburb])&&selectedvalue([locality]) in values(slicer2[locality]),1,0)

 Add the measure to visual filter and set value = 1.

Best Regards,

Jay