Forum Discussion

Foolke's avatar
Foolke
Helper I
6 years ago
Solved

Get value from date slider(slicer)

Hi all, I have a report with a Date slicer.  I want to use the selection of this slider as title in an other visual. I understand that I need to make a measure and use conditional formating....
  • v-yingjl's avatar
    6 years ago

    Hi Foolke ,

    Please delete the'.[Date]' in your measure, it will transfer a larger built-in date table in power bi so that you will get the wrong date value.

    Min date =
    CALCULATE ( MIN ( 'Calendar'[Date] ), ALLSELECTED ( 'Calendar' ) )
    Max Date =
    CALCULATE ( MAX ( 'Calendar'[Date] ), ALLSELECTED ( 'Calendar' ) )
    Selected date = "selected date:" & [Min date] & "-" & [Max Date]

    You will get the right result:

    Also, you can only create single measure by using variance to get the same result:

    Measure = 
    var _mindate = CALCULATE(MIN('Calendar'[Date]),ALLSELECTED('Calendar'))
    var _maxdate = CALCULATE(MAX('Calendar'[Date]),ALLSELECTED('Calendar'))
    return 
    "Selected date:" & _mindate & "-" & _maxdate

     

    Best Regards,
    Yingjie Li

    If this post helps then please consider Accept it as the solution to help the other members find it more quickly.