Forum Discussion
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 ...
You can't make a slicer default to only certain values when you click Select All.
However you could build the logic into a measure:Sum Of Amount (Special Slicer) = IF ( ISFILTERED ( Sales[Item Type] ), SUM ( Sales[Amount] ), CALCULATE ( SUM (Sales[Amount] ), Sales[Item Type] <> "Maintenance" ) )bcdobbs I just downloaded your file and it's working however when i applied to my report it is not. Logic is solid and makes sense not sure why but it is not working on my end.
Here is the code i am using.Special Slicer TY = IF ( ISFILTERED ( 'POS CY'[Slicer]), [POS TY], CALCULATE ( [POS TY], 'POS CY'[Slicer] <> "Maintenance" ) )
Just a thought are you already filtering the column somewhere else eg in the filter pane?
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.