Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
parry2k
Super User
Super User

Date Drill Down

‎07-22-2015 03:42 PM

Does Power BI will have automatic drill down or drill up for date columns ? Like Year -> Qrtr -> Months -> Weeks -> Days -> Time

 

I saw this is a powerful feature  in other BI Tool without doing any special treatment/maintenance of your date field.



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Message 1 of 6
3,016 Views
5 REPLIES 5
ashishrj
Power Participant
Power Participant

‎07-23-2015 03:58 AM

@parry2k Though Power BI soedn't have this feature but DAX functions available in designer/excel can always be used to create calculated columns & measures and apply filter for achieving the same. Anyways having pre-calculated functions for date in Power BI can be great!

Message 3 of 6
3,002 Views
0
Enrico
Frequent Visitor
In response to ashishrj

‎11-26-2015 05:35 AM

Whe are here in the service forum and there's no option to do this like in the desktop version. So it is not implemented yet.

Message 4 of 6
2,874 Views
0
WillT
Community Admin
Community Admin
In response to Enrico

‎12-23-2015 01:16 PM
Hi - we've recently added some basic capability for this. If you use a date field on a chart axis it'll give you the option of different levels Year, Quarter, Month, Day. We're planning to expand this in future releases so please stay tuned for more!
Message 5 of 6
2,817 Views
prokurors
Advocate III
Advocate III
In response to WillT

‎05-22-2016 04:35 PM

This is a nice one 🙂 Although it took a bit more to find this than it should

Message 6 of 6
2,499 Views
0
HarrisMalik
Continued Contributor
Continued Contributor

‎07-23-2015 02:58 AM

There is already an idea of Timeline Slicer, please support it:

https://support.powerbi.com/forums/265200-power-bi/suggestions/7865136-timeline-slicer-for-date-mont...

Message 2 of 6
3,005 Views
0

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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

View All
Top Solution Authors
View All
Top Kudoed Authors
View All