Forum Discussion
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
Hi, try removing the hierarchy created and drag into values the columns: Year, Quarter, Month, Day. (in this order).
Regards
Victor
2 Replies
- Vvelarde
Community Champion
Hi, try removing the hierarchy created and drag into values the columns: Year, Quarter, Month, Day. (in this order).
Regards
Victor
- mrothschild
Continued Contributor
Thanks - that's exactly it!