From the course: Complete Guide to Power BI for Data Analysts by Microsoft Press

Unlock this course with a free trial

Join today to access over 24,800 courses taught by industry experts.

Build an order date hierarchy

Build an order date hierarchy - Power BI Tutorial

From the course: Complete Guide to Power BI for Data Analysts by Microsoft Press

Start my 1-month free trial Buy for my team

Build an order date hierarchy

“

- [Instructor] So we're going to go ahead and build this order date hierarchy. And essentially what we want to do is we want to allow that hierarchy to be utilized on this line chart here right now, because right now it's only showing us the years. I'd like this to be able to drill down to months, and then down to individual days. So let's go ahead and get that order day hierarchy built up. And you're going to follow pretty much the exact same techniques we did earlier on when we built our product hierarchy. The only difference here is this hierarchy we didn't create right off the bat 'cause we didn't really know we needed it. And now we're the visualizations layer. And we said, you know what, we'd like to add some additional functionality to this line chart. So let's go ahead and build that hierarchy, which is going to help support it. So I'm going to go to the model view and we're going to go ahead and build the hierarchy down here in this order date table. Now what I'm going to do…

Contents