Forum Discussion

parry2k's avatar
parry2k
Icon for Super User rankSuper User
11 years ago

Date Drill Down

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 a...
ashishrj's avatar
ashishrj
Icon for Power Participant rankPower Participant
11 years ago

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's avatar
Enrico
Frequent Visitor
10 years ago

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's avatar
    WillT
    Icon for Community Admin rankCommunity Admin
    10 years ago
    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's avatar
      prokurors
      Icon for Advocate III rankAdvocate III
      10 years ago

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