Forum Discussion

robandemmy's avatar
robandemmy
Frequent Visitor
3 years ago

Slicer selections based on another slicer

I have what I think is a simple...ish problem. I have a report built to display machine downtime data. I have a slicer to filter the graphs by month with 12 selectable options (Jan-Dec) along the top. I then have a day slicer underneath that, to drill down to a specific day. Is there an easy way to have the day slicer react to the month slicer? For example, today is December 9th and there is obviously no data for days 10-31, how can I get the day slicer to only show 1-9?

 

Thanks,

Rob

Need Help
Tips and Tricks

1 Reply

  • djurecic's avatar
    djurecic
    Icon for Super User rankSuper User
    3 years ago

    Hi robandemmy ,

     Assuming you have a seperate date table, you could create a column called IsBeforeToday then filter the day slicer to IsBeforeToday=True.

    Something like this:

    IsBeforeToday =
    var currentrowdate= DateTable[Date]
    var today = TODAY() RETURN
    IF(currentrowdate < today,True,False)