Title: Default & Conditional Slicer Setup in Power BI

[Suryateza]

Hi all,

I have a column called ugl, and I want to configure a slicer with specific default and conditional behavior.

Here’s what I need:

• In the slicer for ugl, the following values should be excluded by default:

  '01.04.2027', '01.07.2027', '01.09.2027', '01.01.2028', 'UGL: 27ff', 'unplanned'

• Everything else (including blank values) should be included by default.

• In the slicer dropdown, only the six excluded values above should be available to select (so users can add them back manually).

• If nothing is selected, the report should display the default view, which excludes those six values.

Expected behavior examples:

• All 6 values selected → show everything

• 'UGL: 27ff' selected → show default data + ‘UGL: 27ff’

• 'UGL: 27ff' + '01.04.2027' selected → show default data + those two values

• 'UGL: 27ff' + '01.04.2027' + '01.09.2027' selected → show default data + those three values

• Nothing selected → show default view excluding all 6 values

Has anyone implemented a similar setup — where a slicer starts with specific values excluded by default but can dynamically include them when selected?
Would appreciate suggestions on how to achieve this using DAX logic or a disconnected slicer approach.

Thanks in advance!

[v-karpurapud]

Hi @Suryateza 

We have not received a response from you regarding the query and were following up to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.

Thank You.

[v-karpurapud]

Hi @Suryateza 

Thank you for submitting your question to the Microsoft Fabric Community Forum, and thanks to @grazitti_sapna and @srlabhe  for offering helpful suggestions.

Could you let us know if the suggested solution resolved your issue?If you still need help, please share more details so we can assist you further.

Thank you.

[srlabhe · Accepted solution]

To achieve this complex slicer behavior in Power BI, you will need to create a disconnected support table and a DAX measure. This approach separates the filtering logic for your visuals from the values presented in the slicer. 

Step 1: Create a disconnected support table

Create a new table that contains only the six values you want to show in the slicer dropdown. This table will be disconnected from your main data model, allowing you to control the slicer's available options independently.

dax

ugl Slicer Values = 
DATATABLE(
    "ugl Slicer", STRING, {{ "unplanned" }, { "UGL: 27ff" }, { "01.01.2028" }, { "01.09.2027" }, { "01.07.2027" }, { "01.04.2027" }}
)

Step 2: Create a DAX measure for conditional filtering

This measure will check if any values are selected in the new slicer. If nothing is selected (the default view), it will filter out the six specific values from your report visuals. If a user makes a selection, it will include the selected values and respect the slicer's filter context.

dax

Filter ugl = 
VAR SelectedUgl = VALUES('ugl Slicer'[ugl Slicer])
VAR ExcludedUgl = { "unplanned", "UGL: 27ff", "01.01.2028", "01.09.2027", "01.07.2027", "01.04.2027" }
RETURN
IF(
    // If no values are selected in the slicer...
    ISFILTERED('ugl Slicer'[ugl Slicer]) = FALSE(),
    // Filter out the excluded values from your main ugl column.
    IF(
        SELECTEDVALUE(YourDataTable[ugl]) IN ExcludedUgl,
        0, -- Exclude
        1  -- Include
    ),
    // If values are selected, respect the slicer's selection.
    IF(
        SELECTEDVALUE(YourDataTable[ugl]) IN SelectedUgl,
        1, -- Include selected values
        0  -- Exclude all others
    )
)

Note: Replace YourDataTable with the actual name of your table that contains the ugl column. 

[grazitti_sapna]

Hi @Suryateza,

Create a disconnected table with the values you want to excelude

UGL_Slicer =
DATATABLE(
"UGL", STRING,
{
{"01.04.2027"},
{"01.07.2027"},
{"01.09.2027"},
{"01.01.2028"},
{"UGL: 27ff"},
{"unplanned"}
}
)

Now Create a measure like below

UGL_Filtered =
VAR SelectedValues = VALUES(UGL_Slicer[UGL])
VAR IsAnySelected = COUNTROWS(SelectedValues) > 0
RETURN
IF (
-- If any value in slicer is selected, include default data + selected values
IsAnySelected,
NOT( 'YourTable'[ugl] IN EXCEPT( SelectedValues, BLANK() ) ),
-- If nothing selected, exclude default 6 values
NOT( 'YourTable'[ugl] IN { "01.04.2027", "01.07.2027", "01.09.2027", "01.01.2028", "UGL: 27ff", "unplanned" } )
)

Use this measure as your visual filter

🌟 I hope this solution helps you unlock your Power BI potential! If you found it helpful, click 'Mark as Solution' to guide others toward the answers they need.
💡 Love the effort? Drop the kudos! Your appreciation fuels community spirit and innovation.
🎖 As a proud SuperUser and Microsoft Partner, we’re here to empower your data journey and the Power BI Community at large.
🔗 Curious to explore more? [Discover here].
Let’s keep building smarter solutions together!