Dynamic default slicer

[Manish1198]

Hi community, 
I have two use cases to set default value in the slicer without external visual Preselected slicer (if possible).
Case 1: Set the default value to least open month (Mar-25 in the following example)
Case 2: Set the default value to recent closed month (Feb-25 as per the following example)
Sample data :

Month-Year	Status
Jan-25	Closed
Feb-25	Closed
Mar-25	Open
Apr-25	Open
May-25	Open
Jun-25	Never Opened
Jul-25	Never Opened
Aug-25	Never Opened
Sep-25	Never Opened

The reason for not using Preselected slicer is more space needs to be provided to show the items of the slicer and doesn't align with other slicers.

Thanks

[Manish1198]

Thanks for the suggestion @v-sathmakuri , I appreciate your help.

Using bookmarks and navigation buttons creates a duplicate page experience, which I’m trying to avoid. My goal is to keep the report concise and user-friendly without introducing multiple tabs or navigation complexities.

What I’m looking for is a way to dynamically set the default slicer value (e.g., least open month) when the report loads — but still allow users to select other months from the slicer dropdown. This should ideally be handled within the same page and can use external visuals if aligns with a normal slicer. 

If there is any workaround for this I'd like to hear how you approached it.

[v-sathmakuri]

Hi @Manish1198 ,

I hope the information provided is helpful. Feel free to reach out if you have any further questions or would like to discuss this in more detail. If responses provided answers your question, please accept it as a solution so other community members with similar problems can find a solution faster.

Thank you!!

[v-sathmakuri]

Hi @Manish1198 ,

I wanted to check if you had the chance to review the provided information. Please feel free to contact us if you have any further questions. If the responses have addressed your query, please accept it as a solution so other members in the community can easily find it.

Thank you!!

[v-sathmakuri]

Hi @Manish1198 ,

May I ask if the provided solution helped in resolving the issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you!!

[v-sathmakuri · Accepted solution]

Hi @Manish1198 ,

Thank you for reaching out to Microsoft Fabric Community.

By default, Power BI does not support programmatically setting a default selection in slicers.

However, you can achieve a dynamic slicer experience using bookmarks. I have attached a sample .pbix file by using this approach. After publishing the report to the Power BI Service, the default view will appear as intended. If users wish to access a version of the report with the full slicer for multiple selections, they can do so by clicking the provided navigation buttons.

If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it! 

Thank you!!

[Manish1198]

Thanks for the input @burakkaragoz 
But, this would remove the ability to select months other than the default. The user should be able to select other month as well. 
The 2 cases Least Open Month and Most Recent Closed Month are for two different reports. So, the logic for any one of these would suffice, as i can replicate for the other. 

This will really help me: The slicer should be set to least open month when the user opens the report. And the user should be able to select other months from the slicer dropdown.

[burakkaragoz]

Hi @Manish1198 ,

You can’t set a default slicer value dynamically in visuals directly, but here’s a workaround for both cases:

Case 1 – Least Open Month:

Create a measure like:

LeastOpenMonth = 
CALCULATE(
    MIN('Table'[Month-Year]),
    'Table'[Status] = "Open"
)

Case 2 – Most Recent Closed Month:

RecentClosedMonth = 
CALCULATE(
    MAX('Table'[Month-Year]),
    'Table'[Status] = "Closed"
)

Then create a calculated column:

IsDefault = 
VAR _open = [LeastOpenMonth]
VAR _closed = [RecentClosedMonth]
RETURN
    IF('Table'[Month-Year] = _open || 'Table'[Month-Year] = _closed, 1, 0)

Use this column to filter the slicer to show only the default value.

This doesn’t auto-select the value in the slicer, but it limits the slicer to just that value — which works like a default.

Let me know if you want to switch between the two cases dynamically.

---

If my response resolved your query, kindly mark it as the Accepted Solution to assist others. Additionally, I would be grateful for a 'Kudos' if you found my response helpful.
translation and formatting supported by AI