cancel
Showing results for 
Search instead for 
Did you mean: 
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



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

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



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

thx @amitchandak !

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