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

Overview

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.

https://github.com/Dhruvinshah16/Power-BI/tree/master/PBI-Year-QTY-MonthDrillDownSample


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".