Forum Discussion
Dynamically Enable and Disable Date Dropdown
Hi , Thank you for reaching out to the Microsoft Community Forum.
Can you provide more details, because the behaviour depends entirely on how your tables are structured. Specifically, could you confirm whether the Period table is connected to the Date table and share the relationship type and cross-filter direction and whether the Period slicer is based on a disconnected table? A simple model diagram or a stripped-down PBIX with very small sample data would be ideal. The reason this matters is that slicers only react to actual filter propagation in the data model, so whether Period physically filters Date or only drives measures changes the solution completely.
Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Hi v-hashadapu
i publish the link to download the pbix file.
Are you able to download it?
Let me know.
Hi lucadelicio , Thank you for reaching out to the Microsoft Community Forum.
Your Filter Period table is completely disconnected from the Date table without any relationship. So, when you change Period, it does not actually filter the Date table, it only affects your measures. Since slicers populate their values directly from the underlying column, the Date slicer has no filter context to react to, which is why it keeps previous selections or shows All instead of becoming empty.
Power BI also cannot dynamically clear or truly disable a slicer based on another slicer in this setup. You would need either bookmarks to reset the slicer, a UI workaround (like conditionally hiding/overlaying the Date slicer) or a different model design where Period physically filters the Date table.