Drill down from date to datetime

Hi BeautifulDash 

Please consider using DrillThrough.

While you've mentioned that drilling down to datetime granularity is not directly possible with the date hierarchy, consider using the drillthrough feature in Power BI to create a detailed page that focuses on a single day's data. Users can then select a specific day from the main report page and drill through to the detailed page to see data at the datetime level. This method provides a user-friendly way to navigate from aggregated data to detailed data.

Here I create a set of sample:

Then add a calculated column:

Date = DATE(YEAR('Table'[DateTime]),MONTH('Table'[DateTime]),DAY('Table'[DateTime]))

And change the type of the column into date (yyyy-mm-dd)

Then add a clustered column chart with Date and Value field:

Then in page 2, add a clustered column chart with Datetime and Value field:

Then drag the Date field into the drillthrough bin, you can right-click the clustered column and select the drill through > page 2 to achieve similar operations.

Here for your reference:

Set up drillthrough in Power BI reports - Power BI | Microsoft Learn

Best Regards

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