Forum Discussion

BimalSubhasis's avatar
BimalSubhasis
Advocate 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 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.

Please help me with the best possible solution. Appreciate your help here. 

 

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

amitchandak Greg_Deckler PowerBIDev JihwanKim Jihwan_Kim 

 

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

2 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community 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")