cancel
Showing results for
Did you mean:

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

## Urgent Help: Multiple slicer control with same dataset

Hi All,

I have a client request to give the user option to select the slicers based on the city priority. Meaning, while the user select one city from slicer1 it should disappear from the next slicer or from all the slicer.

The solution as per my understanding - I have created 6 different tables and used below DAX on slice2 but not sure how to proceed from slice3 and so on. I used a filter on this visual option and hide the city selected in slice1.

Slicer2 =
Var slicer1 = SELECTEDVALUE('CIty (2)'[City])
Var slicer2 = SELECTEDVALUE('CIty (3)'[City])
return
if(slicer1 = slicer2,
"Hide",
"Keep")

1 ACCEPTED SOLUTION
Super User

@BimalSubhasis Try:

``````Slicer2 =
Var slicer1 = SELECTEDVALUE('City'[City])
Var slicer2 = MAX('City (2)'[City])
return
if(slicer1 = slicer2,
"Hide",
"Keep")

Slicer3 =
Var slicers = { SELECTEDVALUE('City'[City]), SELECTEDVALUE('City (2)'[City]) }
Var slicer = MAX('City (3)'[City])
return
if(slicer IN slicers,
"Hide",
"Keep")

Slicer4 =
Var slicers = { SELECTEDVALUE('City'[City]), SELECTEDVALUE('City (2)'[City]), SELECTEDVALUE('City (3)'[City]) }
Var slicer = MAX('City (4)'[City])
return
if(slicer IN slicers,
"Hide",
"Keep")
``````

Become an expert!: Enterprise DNA
External Tools: MSHGQM
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...
2 REPLIES 2
Super User

@BimalSubhasis Try:

``````Slicer2 =
Var slicer1 = SELECTEDVALUE('City'[City])
Var slicer2 = MAX('City (2)'[City])
return
if(slicer1 = slicer2,
"Hide",
"Keep")

Slicer3 =
Var slicers = { SELECTEDVALUE('City'[City]), SELECTEDVALUE('City (2)'[City]) }
Var slicer = MAX('City (3)'[City])
return
if(slicer IN slicers,
"Hide",
"Keep")

Slicer4 =
Var slicers = { SELECTEDVALUE('City'[City]), SELECTEDVALUE('City (2)'[City]), SELECTEDVALUE('City (3)'[City]) }
Var slicer = MAX('City (4)'[City])
return
if(slicer IN slicers,
"Hide",
"Keep")
``````

Become an expert!: Enterprise DNA
External Tools: MSHGQM
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

Many Thanks @Greg_Deckler. It works for me. Do you have any suggestions to improve advanced DAX logics.