Forum Discussion

mirzay's avatar
mirzay
Icon for Helper I rankHelper I
10 years ago

Automatic date column drill down not working as advertised

I followed the process in this tutorial here.  I have a simple revenue dashboard that I want to display revenue by year, quarter, month, day. I move the date column (type = date) in the X-Axis ...
Need Help
Habib's avatar
Habib
Icon for Continued Contributor rankContinued Contributor
10 years ago

Right Click on Date in X-Axis under settings and See if "Date" option is selcted or "Hierarchy". It should be hierarchy for drilldown feature.

 

 

mirzay's avatar
mirzay
Icon for Helper I rankHelper I
10 years ago

All I see is Remove Field and Show Options with no data.

  • mirzay's avatar
    mirzay
    Icon for Helper I rankHelper I
    10 years ago

    I have a workaround if anyone else expereinces this. I duplicated the Date column as Date_1 in the model and ensured the type was also set to a type Date. If I use this new column, I get the hierarchy and it does what I want to do. 

     

    I just marked the original Date column to do not show so there is no confusion when creating reports.

     

    Seems like a Power BI bug to me.

    • ngg4686's avatar
      ngg4686
      Frequent Visitor
      10 years ago

      You aren't the only one that this is happening to.  it seems like PowerBI isn't recgonizing the field as a date, so by adding a new column using the formula (my example anyway)

       

      Act Ship Date = DATEVALUE('Source'[Ship Date]

       

      If you do this, then the ship date behaves as expected.

    • Anonymous's avatar
      Anonymous
      Not applicable
      10 years ago

      Are you using a dedicated date table or just a date type column in your regular data table?

      • mirzay's avatar
        mirzay
        Icon for Helper I rankHelper I
        10 years ago

        This is a date column in a fact table, not the Data table.