Forum Discussion

CraigDon's avatar
CraigDon
New Member
8 years ago

Multiple Date Filters on Same Report

Hi,

 

I have a report with two visuals. One of those visuals should be filtered to show only transactions for the week selected in the date slicer, the other visual needs to show all transactions up to the date of the slicer.

 

For example in the below. the cash variance should only show transactions with w/e/ date 01/04/18, but the unbanked visual should be all transactions up to 01/04/18;

 

Any help would be appreciated.

 

Thanks,

 

 

Craig

Need Help

1 Reply

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee
    8 years ago

    Hi CraigDon,

     

    There is a function "Edit interactions" that can block the filtering of the slicer. But maybe you need a measure to workaround the slicer. Please share a dummy sample in order to write down the DAX formula. It could be something like this. (just a pseudo-code)

    Measure = 
calculate(if(unbanked[date] < max('date'[rptdatewekend]), 1, 0), all('date'))

    Best Regards,

    Dale