Re: Date Drill Down

parry2k · ‎07-22-2015

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.

ashishrj · ‎07-23-2015

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

Enrico · ‎11-26-2015

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.

WillT · ‎12-23-2015

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!

prokurors · ‎05-22-2016

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

HarrisMalik · ‎07-23-2015

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

Date Drill Down

Helpful resources

Power BI Monthly Update - October 2024

Fabric Community Update - October 2024