Time slicer to filter measures

Hi learned brethren,
I have 3 sets of data cards low/med/high categories.
for each set … there are 3 corresponding measures; SUM of values 2018, SUM of values 2019 and the %change.

The SUM for e.g… 2018 uses the DATESBETWEEN function, same for 2019.

What I would like to do is use a date slicer that when selected, for any given dates, changes the SUM for 2018, 2019 and of course the %change.

TIA John


Please take a look at the first half of the following thread and see if it helps address your question:

If not, please post your PBIX which will make it much easier to provide a specific solution.


  • Brian

Hi @jmaikido, we’ve noticed that no response has been received from you since December 06, 2019. We just want to check if you still need further help on this post? In case there won’t be any activity on it in the next few days, we’ll be tagging this post as Solved. You may reopen a new thread when the need arises.