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....
Need Help
  • v-yingjl's avatar
    v-yingjl
    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.

amitchandak's avatar
amitchandak
Super User
6 years ago

Foolke 

hope these are measures and not columns. The slicer is on closed_date.

 

Try a measure like this

measure =
var _min = MINX(ALLSELECTED('PMCC Tickets Closed'),'PMCC Tickets Closed'[Closed_Date] )
var _max = MAXX(ALLSELECTED('PMCC Tickets Closed'),'PMCC Tickets Closed'[Closed_Date] )
return
"Closed entries per user for the period" & _min & " - " & _max