Get date slider value (slicer)

[Foolke]

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 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:

there is a difference between selected and displayed.

How can I solve this?

[amitchandak · Accepted solution]

@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

[Foolke]

thx @amitchandak !