Forum Discussion

dokat's avatar
dokat
Icon for Post Prodigy rankPost Prodigy
4 years ago
Solved

Slicer Select all option while excluding one value

Hi, I am trying to create a slicer and have select all option but want to exclude one value from the selectall.   Here are the four values for the sicer.  I'd like to have select all options only ...
Need Help
dokat's avatar
dokat
Icon for Post Prodigy rankPost Prodigy
4 years ago

bcdobbs I double checked it, i am not using any other filters. However i am using if functions within {POS TY] not sure if this is causing the problem. Below is the formula for [POS TY]

 

POS TY = IF(SELECTEDVALUE('POS CY'[Slicer])={"L52W"},Calculate(SUM('POS'[Values]),'POS CY'[Slicer] IN {"L52W"}),IF(SELECTEDVALUE('POS CY'[Slicer])={"L4W"},Calculate(SUM('POS'[Values]),'POS CY'[Slicer] IN {"L4W"}),IF(SELECTEDVALUE('POS CY'[Slicer])={"L13W"},Calculate(SUM('POS'[Values]),'POS CY'[Slicer] IN {"L13W"}))))

Unfortunately, there is confidential information in the data, hard to share it without exposing it.

bcdobbs's avatar
bcdobbs
Icon for Community Champion rankCommunity Champion
4 years ago

I'll try and rewrite that but it will be tomorrow morning (uk time).

  • dokat's avatar
    dokat
    Icon for Post Prodigy rankPost Prodigy
    4 years ago

    bcdobbs Thanks for your response. I fixed the issue is slicer selection. Code is working perfect. no need to rewrite. Thanks for all your help.