Forum Discussion
lizardi89
Helper I
Helper IDynamic range date slicer
Hello, I need help with a dynamic date slicer please... So, I have two tables, one with client contract info and another with historic info from multiple clients. I need to have a dynamic dat...
littlemojopuppy
Community Champion
Community ChampionSounds like you want to have the date slicer filter based on the selected client. If you create a second slicer for Client and make sure it filters the date slicer, it could work.
I am course saying this without having any knowledge of your data model...you'll probably need a relationship between the date table and signature date.
lizardi89Helper I
Helper IYes I already tried that and it didn't work...
- littlemojopuppy
Can you share your PBIX?
- lizardi89
- littlemojopuppy
Please do the following in your PBIX:
- Change the formula for your Cal Filter table to CALENDARAUTO()
- Mark it as a date table
- Slide the date slicer down a bit away from the client slicer to give yourself some room.
- Click the Client slicer then go to Format > Edit Interactions. Make sure that the slicer is set to filter (see my earlier pic)
- Add Signature Date to the slicer instead of Cal Filter[Date]
You should be set...