Forum Discussion

Foolke's avatar
Foolke
Helper I
6 years ago
Solved

Get date slider value (slicer)

Hello everyone I have a report with a date segmentation. I want to use the selection of this slider as a title in another visual. I understand that I need to make a measure and use conditional...
  • amitchandak's avatar
    amitchandak
    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

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