power bi Default Slicer
_Default Slicer =
VAR _total =
CALCULATE ( DISTINCTCOUNT ( P[Product] ), ALL ( P[Product] ) )
VAR _ProductList =
SUMMARIZE ( ALLSELECTED ( P ), P[Product] )
VAR _countSelected =
COUNTROWS ( _ProductList )
VAR _except_Default = { "VTT" }
// we can also set a list of default selected values like:
// var _selected_Default={"VTT"}
// just to change the "N" to "Y".
VAR _if =
IF (
_countSelected < _total,
IF ( MAX ( 'financials'[Product] ) IN _ProductList, "Y", "N" ),
IF ( MAX ( 'financials'[Product] ) IN _except_Default, "N", "Y" )
)
RETURN
_if