Forum Discussion
Helper IVIs 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 that if you do select two dates, or 3 or 4 etc, it only shows me the values of most recent date.
Thanks
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
3 Replies
- Greg_Deckler
Community Champion
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
- Chihiro
Solution Sage
Sure, it's possible. You'll have to filter measure for [Date]=MAX([Date]).
v-juanli-msftCommunity Support
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
