Forum Discussion

Charles-CW's avatar
Charles-CW
Icon for Advocate I rankAdvocate I
3 years ago

Show value from selected slicer with multiple slicers from same table

Good day all,

I need some advise please.

I have a custom table as seen below which I want to use for slicers.

The challenge I am having is retrieving only the selected value from the individual slicers. I have disabled the interaction between the slicers so that they would not affect each other but I am not able to retrieve the value on the individual selected slicer.

If all my values from all the slicers are the same then I am returning the value based on the DAX measure but as soon as I select different values then I get Blank() results. 

I fully understand why I am getting these blank() results and I am hoping there is a measure that I can use to only display the value of the current slicer as seen in the "Slicer x Desired Value" in the images below i.e.: break it up like disabling the interaction between the slicers.

Custom Table

 

Results if all slicers are on the same value - based on the dax measure

 

Results when different slicer values are selected - Also note that the interaction between the slicers are disabled

 

Slicer 1 Value measure tried but not working

 

Slicer 2 Value measure tried but not working 

 

Slicer 3 Value measure tried but not working - Not getting a blank but not getting the correct result either.

 

Slicer 4 Value measure tried but not working 

 

Slicer 5 Value measure tried but not working

 

Desried values - This is where I am stuck 😞

 

I am sure and hope it might be something simple where I would not have to create 5 different slicer tables.

5 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion

    Charles-CW Can you post an example file or data as text? I am concerned that this is an AutoExist issue and if that is indeed the case, then the only answer might be to unpivot your rows perhaps.

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion

    Charles-CW I went ahead and mocked this up. It's definitely an autoexist issue. Even unpivoting doesn't help because of autoexist. You need 5 disconnected slicer tables. The upside is that you don't need to worry about edit interactions. See attached PBIX below signature.

     

    • Charles-CW's avatar
      Charles-CW
      Icon for Advocate I rankAdvocate I

      Greg_Deckler, thank you.

       

      I was hoping to get away from the 5 additional tables.

       

      On the plus side I now don't feel to bad for not being able to get this to work.

      • Greg_Deckler's avatar
        Greg_Deckler
        Icon for Community Champion rankCommunity Champion

        Charles-CW Once you hit an autoexist issue, it's all over. Wish they would allow you to toggle that off...