Forum Discussion
Dynamically Enable and Disable Date Dropdown
What I want is not for the measures to be calculated over a specific period they already do that, and the slicers are meant precisely to allow choosing a specific or custom period.
What I want is that, when I select a specific period, the date slicer does not show years that have nothing to do with the selection, because they only confuse the user.
These are the real limitations of Power BI’s user experience that I don’t understand.
I’m waiting for some official answers from Microsoft.
Thanks anyway for your help.
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.
