Slicer selections based on another slicer

[robandemmy]

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

[djurecicK2]

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)