Forum Discussion
Helper IHow to add drill down in line chart?
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.
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.
1 Reply
- AllisonKennedy
Community Champion
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.