Forum Discussion
Slicer Select all option while excluding one value
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" ) )
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"
)
)
Community ChampionJust a thought are you already filtering the column somewhere else eg in the filter pane?
bcdobbs I figured out the issue, it was with POS CY [Slicer]. It is working right now. Thanks for your help.
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.