Multiple Date Filters on Same Report

[CraigDon]

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

[v-jiascu-msft]

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