Time slicer to filter measures

[jmaikido]

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

[BrianJ]

@jmaikido,

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

Capture date from Date Slicer

@axaeffect, Here’s a link with one way to do this: https://community.powerbi.com/t5/Desktop/Get-start-and-end-date-from-Timeline-Slicer/td-p/71317 Basically, just MIN and MAX of ALLSELECTED on your date field. SELECTEDVALUE returns a blank since it doesn’t know which of the two dates to select (to me, it would make more sense if it returned an error message instead, noting the ambiguity). Hope this is helpful. Brian

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

Thanks.

• Brian

[EnterpriseDNA]

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.