cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Foolke
Helper I
Helper I

Get value from date slider(slicer)

Hi all,

I have a report with a Date slicer. 

slider.png

I want to use the selection of this slider as title in an other visual.

I understand that I need to make a measure and use conditional formating. 

How do I create the measure? I foolowed the solution from How to get value from date slicer . This result in this code

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

 Last measure is used as conditional format value.

 

This gives this result:

slider.png

 

there is a difference between selected and displayed.

How can I solve this?

1 ACCEPTED SOLUTION
v-yingjl
Community Support
Community Support

Hi @Foolke ,

Please delete the'.[Date]' in your measure, it will transfer a larger built-in date table in power bi so that you will get the wrong date value.

Min date =
CALCULATE ( MIN ( 'Calendar'[Date] ), ALLSELECTED ( 'Calendar' ) )
Max Date =
CALCULATE ( MAX ( 'Calendar'[Date] ), ALLSELECTED ( 'Calendar' ) )
Selected date = "selected date:" & [Min date] & "-" & [Max Date]

You will get the right result:

get value in date slicer.png

Also, you can only create single measure by using variance to get the same result:

Measure = 
var _mindate = CALCULATE(MIN('Calendar'[Date]),ALLSELECTED('Calendar'))
var _maxdate = CALCULATE(MAX('Calendar'[Date]),ALLSELECTED('Calendar'))
return 
"Selected date:" & _mindate & "-" & _maxdate

 

Best Regards,
Yingjie Li

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
v-yingjl
Community Support
Community Support

Hi @Foolke ,

Please delete the'.[Date]' in your measure, it will transfer a larger built-in date table in power bi so that you will get the wrong date value.

Min date =
CALCULATE ( MIN ( 'Calendar'[Date] ), ALLSELECTED ( 'Calendar' ) )
Max Date =
CALCULATE ( MAX ( 'Calendar'[Date] ), ALLSELECTED ( 'Calendar' ) )
Selected date = "selected date:" & [Min date] & "-" & [Max Date]

You will get the right result:

get value in date slicer.png

Also, you can only create single measure by using variance to get the same result:

Measure = 
var _mindate = CALCULATE(MIN('Calendar'[Date]),ALLSELECTED('Calendar'))
var _maxdate = CALCULATE(MAX('Calendar'[Date]),ALLSELECTED('Calendar'))
return 
"Selected date:" & _mindate & "-" & _maxdate

 

Best Regards,
Yingjie Li

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

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



New Power BI Features
Datamarts: https://youtu.be/8tskWsJTEpg
Field Parameters : https://youtu.be/lqF3Wa1FllE?t=70
Did I answer your question? Mark my post as a solution! Appreciate your Kudos!! !!
Dashboard of My Blogs !! Connect on Linkedin !! Proud to be a Super User!
Want To Learn Power BI
Learn Power BI Beginners !! Advance Power BI Concepts !! Power BI For Tableau User !! Learn Power BI in Hindi !!
!! Subscribe to my youtube Channel !!

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Power BI Dev Camp Session 23 768x460.jpg

Check it Out!

Mark your calendars and join us on Thursday, June 30 at 11a PDT for a great session with Ted Pattison!

June 20 episode 7 with aka link 768x460.jpg

The Power BI Community Show

Join us on June 20 at 11 am PDT when Kim Manis shares the latest on Azure Synapse analytics, the Microsoft Intelligent Data Platform, and notable Power BI Updates from Microsoft Build 2022.

Top Solution Authors
Top Kudoed Authors