Forum Discussion
Jason2500
Helper I
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 o...
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.
AllisonKennedy
Community Champion
Community ChampionJason2500 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.