Forum Discussion
Solved
Is this possible?
Hi Guys, Is this possible ...... With the date slicer, it shows my figures as it should when I have one date selected, when I select two dates, it adds the values together, is there a way tha...
Hi KH11NDR
there is a way that if you do select two dates, or 3 or 4 etc, it only shows me the values of most recent date.
Create a measure to define today
today = TODAY()
Then create a calculated column to calculate how many days away from today
days from today = ABS(DATEDIFF(Sheet1[date],[today],DAY))
next create measures to find the most recent date (away from today) based on the selected values with the slicer.
most recent day = CALCULATE(MIN([days from today]),ALLSELECTED(Sheet1))
flag = IF([most recent day]=MAX([days from today]),1,0)Finally, add "flag" measure to the Visual Level filter, then set "show value when item" is 1.
Best Regards
Maggie
Sure, it's possible. You'll have to filter measure for [Date]=MAX([Date]).