Forum Discussion
Exclude orders that contain a specific item
- Anonymous4 years ago
Hi robbinkees1,
Currently, you cant use a slicer to achieve the selector effect which you mentioned.
For your requirement, I'd like to suggest you create a new table with all selected values which not have a relationship to the raw table and use it as a source of the slicer.Then you can write a measure to check the current value and selected value to return flags and use it on the 'visual level filter' to achieve exclude filter effects.
Measure formula to filter selected records:
Exclude Flag = VAR selected = VALUES ( NewTable[item] ) VAR currItem = SELECTEDVALUE ( Table[item] ) RETURN IF ( currItem IN selected, "N", "Y" )Applying a measure filter in Power BI - SQLBI
Regards,Xiaoxin Sheng
Hi robbinkees1,
Currently, you cant use a slicer to achieve the selector effect which you mentioned.
For your requirement, I'd like to suggest you create a new table with all selected values which not have a relationship to the raw table and use it as a source of the slicer.
Then you can write a measure to check the current value and selected value to return flags and use it on the 'visual level filter' to achieve exclude filter effects.
Measure formula to filter selected records:
Exclude Flag =
VAR selected =
VALUES ( NewTable[item] )
VAR currItem =
SELECTEDVALUE ( Table[item] )
RETURN
IF ( currItem IN selected, "N", "Y" )
Applying a measure filter in Power BI - SQLBI
Regards,
Xiaoxin Sheng