Dynamic Filter syncronization

[Hariharanb47]

I am building a dashboard in which user will be provided with two primary filters one is for Date and another is for employee status which are created as buttons namely 'Active','Terminated' and 'All'. When terminated button is clicked a date slicer will be shown which should be used for filtering the data and the date range should be limited to the dates selected in the above primary date filter and whenever date range is selected in the primary date filter the date range should be limited in the termination date filter and the visuals should be responsive only to termination filter and primary filter is only for setting the date range. I have done all the things but I couldn't able to dynamically date range selected in primary date filter in the secondary date filter. Help me in achieving this or let me know this is even possible in PowerBI

[v-veshwara-msft]

Hi @Hariharanb47 ,

Just checking in to see if you query is resolved and if any responses were helpful.
Otherwise, feel free to reach out for further assistance.

Thank you.

[v-veshwara-msft]

Hi @Hariharanb47 ,
Just wanted to check if the responses provided were helpful. If further assistance is needed, please reach out.
Thank you.

[v-veshwara-msft · Accepted solution]

Hi @Hariharanb47 ,

Thanks for posting your question in the community, and thanks to @Praful_Potphode for the suggestion regarding using bookmarks to control the visibility of the secondary slicer based on the status selection.

Just to add some context. Power BI currently does not support dynamically restricting the selectable date range of one slicer based on another slicer’s selection. Even when the UI visibility is managed through bookmarks, both slicers still behave independently in terms of their available range.

A common workaround is to keep the primary date slicer disconnected from the model and use DAX in the visuals so that the termination date slicer is what actually drives the results, while the primary slicer only defines the allowed boundary.

Here are some similar threads:
Solved: Dynamically Limit End Date of a Power BI Slicer Ba... - Microsoft Fabric Community

Solved: Slicer Filtering Another slicer - Microsoft Fabric Community

Solved: Filter Slicer values based on another slicer - Microsoft Fabric Community

Hope this helps. Please reach out for further assistance.

Thank you.

[Praful_Potphode]

Hi @Hariharanb47 ,

Explore Bookmarks in PowerBI, they allow visuals to be hidden/visible based on button selection.

Please give kudos or mark it as solution once confirmed.

Thanks and Regards,

Praful