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.

slider.png

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 formatting.

How do I create the measure? I have cheated on the solution of How to Get Value from Date Segmentation. This results in this code

ms_Min selected closing date s CALCULATE(MIN('PMCC Tickets Closed'[Closed_Date].[ Date]); ALLSELECTED('PMCC Tickets Closed'))
ms_Max selected closing date s CALCULATE(MAX('PMCC Tickets Closed'[Closed_Date].[ Date]); ALLSELECTED('PMCC Tickets Closed'))
ms_Selected Closing Date: "Closed entries per user for the period" & [ms_Min selected closed date] & " - " & [ms_Max selected closed date]

The last measurement is used as the conditional formatting value.

This gives this result:

slider.png

there is a difference between selected and displayed.

How can I solve this?

  • 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

2 Replies

  • 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