Forum Discussion
Dynamic 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...
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...