Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
DanCasSan
Helper V
Helper V

Get the data that has been filtered in a TIMELINE

Hello community, is it possible that through a DAX function I can show a selected date of a TIMELINE? For example, I want to get the minimum date of the year that I have selected in the image.

 

TimeLine.JPG

 

Thanks for your support!

6 REPLIES 6
v-yingjl
Community Support
Community Support

Hi @DanCasSan ,

You can use the 'Timeline 2.1.1' visual to select a timeline and create the following measure to get the start date and end date:

Start Date =
CALCULATE ( MIN ( 'Table'[Date] ), ALLSELECTED ( 'Table'[Date] ) )
End Date =
CALCULATE ( MAX ( 'Table'[Date] ), ALLSELECTED ( 'Table'[Date] ) )

The following result may be your expected:

date timeline.png

Here is the same issue that you can also refer: Get start and end date from Timeline Slicer 

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.

This worked for me wonderfully. Thank you! 😎

Greg_Deckler
Super User
Super User

Well, let's say that you are using Date column from Calendar table, then you would do this:

 

Minimum Measure = MIN('Calendar'[Date])


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

Yes. But if I put the minimum, I will get the minimum date of the entire table, for this example the date would be 01/01/2016, and what I need is the date 01/01/2018 (the year that is being selected).

Hi,

As long as you drag Date from the Calendar Table to the slicer, Greg's suggestion should definitely work.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

@DanCasSan , Somehow I see Day timeline 2.1.1

Screenshot 2020-05-01 08.16.26.png

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.