Forum Discussion

mrothschild's avatar
mrothschild
Icon for Continued Contributor rankContinued Contributor
7 years ago
Solved

deeper drilldown on waterfall chart?

PBIX File here: https://www.dropbox.com/s/rbjoqspdjdmtquq/Power%20BI%20Forum%20Sample.pbix?dl=0

 

I changed from the internal date hierarchy table to one that's described here: https://www.sqlbi.com/articles/reference-date-table-in-dax-and-power-bi/

 

I'm trying to figure out how to drill down on my waterfall chart on Page 4 of the BI file linked above to time frames more frequent than annual and I'm at a loss.  I'm pretty sure I was able to do this with the embedded date hierarchy, but I've only been using BI for a few weeks so still very green.

 

Thanks

  • mrothschild 

     

    Hi, try removing the hierarchy created and drag into values the columns: Year, Quarter, Month, Day. (in this order).

     

    Regards

     

    Victor

2 Replies

  • Vvelarde's avatar
    Vvelarde
    Icon for Community Champion rankCommunity Champion

    mrothschild 

     

    Hi, try removing the hierarchy created and drag into values the columns: Year, Quarter, Month, Day. (in this order).

     

    Regards

     

    Victor