How to add drill down in line chart?

[Jason2500]

Hi 

I am a newbie in Power BI and learning a lot with the help of this amazing community. I am trying to add drill down feature to my line chart

My data as follow

Getting below output

I want to create a line chart to highlight the profits, with adding a drill down/up feature, where profits can be visualized at monthly, quarterly and annual level?

I am getting a line chart but getting the above drill-down features? Please advise.

[AllisonKennedy · Accepted solution]

@Jason2500  do you have a DimDate table? https://excelwithallison.blogspot.com/2020/04/dimdate-what-why-and-how.html

Once you have a date table, you can use the Year, Quarter, Month columns all in the 'axis' field for the line chart to get the drilldown hierarchy you're looking for.