Forum Discussion
Button to filter dates based on another field/slicer
Maybe I can break this down into parts and see if someone can help with the individual steps.
What's the best way to filter a date slicer based on another slicer (the video subject)? Perhaps if I can start there, then I can move on to figuring out how to set up the dates relative to the video release date.
Community SupportHi Anonymous
Do we only need to show data about the selected video in this page, right? (You will not select multiple videos in the video slicer?) If so, it is possible to realize. At present I have two ideas: one is to use measures to calculate the views data with date filters in them and use slicer to switch options rather than buttons; the other idea is to use bookmarks. I will update here with a sample maybe tomorrow.
Regards,
Community Support Team _ Jing
Yep, correct - one video at a time. Appreciate the help!
- v-jingzhang
Hi Anonymous
I remove the relationship between two tables, add another table for date range slicer and create several measures. I use a slicer to replace the buttons. In format pane > General > Orientation, select Horizontal rather than Vertical for the slicer. The options appear like buttons.
I didn't consider Weekday in this sample. When you mentioned Weekday in the original post, do you want to show the next 3/7/14 workdays in the page? If so, I need to modify the report.
Let me know if you have any questions.
Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.