Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Button to filter dates based on another field/slicer

I have a series of videos, each with a release date roughly a month apart. I have views for each day going forward from release. I want buttons that will filter the entire page from the release date ...
Need Help
v-jingzhang's avatar
v-jingzhang
Icon for Community Support rankCommunity Support
5 years ago

Hi 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

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Yep, correct - one video at a time. Appreciate the help!

  • v-jingzhang's avatar
    v-jingzhang
    Icon for Community Support rankCommunity Support
    5 years ago

    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.