Forum Discussion
Post ProdigyHow can I make my date slicer to work dynamically?
Is it possible to make a date slicer which change it self when i select a year? or a quater? Suppose I select a quater or a year or a month in my different slicers, the date period should show me all the dates between all those periods? is it possible in PowerBI to do this?
Hi Anmolgan ,
You can find the option here:
Detailed usage refer to the official document: https://docs.microsoft.com/en-us/power-bi/service-reports-visual-interactions
14 Replies
- Cmcmahan
Resident Rockstar
Yes, it should happen automatically. As long as they're slicing on the same table or related tables, slicers filter each other by default, unless you specify otherwise.
AnmolganI have built out the relationships among the 3 tables, but how can I specify this specifically to the date slicer that it needs to sort out.
- Cmcmahan
Is the date slicer running against a fact table or a date table?
Can you share the .pbix with us? There are a lot of ways to set up relationships between 3 tables and slicers among those.
