Create Year Quarter Month Drill Down With Proper Sort Order In Power BI


In Power BI, we can achieve drill-down functionality. Power BI facilitates Year-QTY-Month drill down automatically for the columns which have the Date data type.

Now, there are some situations in which we do not have a Date Column available in our dataset. At that time, what to do to achieve the drill down?

I have added some sample data source and Power BI file on GitHub. You can download it using the following link.

This article is the solution for this.

Let’s get started!

We have the following types of datasets. We have columns,

  • Year

  • Qty

  • Month

Now, let us load the data in Power BI.

Step 1

Go to Home and click on "Edit Queries".