Is this possible?

[KH11NDR]

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 that if you do select two dates, or 3 or 4 etc, it only shows me the values of most recent date.  

Thanks

[v-juanli-msft · Accepted solution]

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

[Chihiro]

Sure, it's possible. You'll have to filter measure for [Date]=MAX([Date]).

[Greg_Deckler]

Possible, you would add a VAR __mostrecent = MAX('Table'[Date]) and then use that to decide whether to show something or not. Difficult to say though with the information provided. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490