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

vanessafvg's avatar
vanessafvg
Icon for Community Champion rankCommunity Champion
5 years ago

you would need to create the time fields and then stack the fields on top of each other, so assign a value to each level of granularity as the year quarter month date is.  It really depends on what type of analysis you are trying to do.  Usually its best practise to separate the date and time fields and do analysis on them separately.  if you supply some data in text form that would be useful to show you.