cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper I

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

1 ACCEPTED SOLUTION
Super User

@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 2
Super User

@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

Helper I

thx @amitchandak !