Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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
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]).
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |