Skip to main content
cancel
Showing results for 
Search instead 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

Reply
Foolke
Helper I
Helper I

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?

1 ACCEPTED SOLUTION
amitchandak
Super User
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

View solution in original post

2 REPLIES 2
amitchandak
Super User
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

thx @amitchandak !

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors