Can we drill from Daily Data to Hourly Data

Hi Anonymous 

It should be possible. You can create a drillthrough destination page and add visuals with hourly data on it. Then, on that drillthrough page, in the Fields section of the Visualizations pane, drag the field for which you want to enable drillthrough into the Drillthrough filters well.

Since your hourly data and daily data are in different tables, you need to ensure that daily table is able to filter hourly data through the relationship between them. You can test this before setting up drillthrough. Dragging data columns from both tables into the same visual (e.g. a table visual) to check whether hourly data are matched to corresponding daily data correctly. 

See Set up drillthrough in Power BI reports - Power BI | Microsoft Docs

In addition, if you want to drill to hourly data in the same visual, try Drill down and drill up in a visual.

Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.