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