Forum Discussion

KH11NDR's avatar
KH11NDR
Helper IV
7 years ago
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...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    7 years ago

    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

v-juanli-msft's avatar
v-juanli-msft
Community Support
7 years ago

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