Forum Discussion

G3N3XT's avatar
G3N3XT
Frequent Visitor
5 years ago
Solved

Smarter DateTime drill down aggregation?

Hi all,    The default drill down behavior in PowerBI is that when using drill down for lets say from year -> day (this can be via quarter and month), it provides me with the the data per day of th...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    HI G3N3XT,

    So you mean to drill through the records into time level? If that is the case, drill your records to the detail level(second) of time values and it will expand the records and obviously affect the performance.

    In my opinion, I'd like to suggest you create a stand-alone timetable that accurately to the seconds level.
    Then you can build the visuals that summary on date levels and design a report page with time level records that link to the raw table with 'drill through' features and filter on the date filter.

    Set up drill through in Power BI reports 
    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
5 years ago

HI G3N3XT,

So you mean to drill through the records into time level? If that is the case, drill your records to the detail level(second) of time values and it will expand the records and obviously affect the performance.

In my opinion, I'd like to suggest you create a stand-alone timetable that accurately to the seconds level.
Then you can build the visuals that summary on date levels and design a report page with time level records that link to the raw table with 'drill through' features and filter on the date filter.

Set up drill through in Power BI reports 
Regards,

Xiaoxin Sheng