Forum Discussion

BimalSubhasis's avatar
BimalSubhasis
Icon for Advocate III rankAdvocate III
3 years ago
Solved

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 slic...
Need Help
Tutorial Requests
  • Greg_Deckler's avatar
    Greg_Deckler
    3 years ago

    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")
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
3 years ago

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")
BimalSubhasis's avatar
BimalSubhasis
Icon for Advocate III rankAdvocate III
3 years ago

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