Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
helen_p
Frequent Visitor

Can you have drill down functionality on Legend and Axis on a line chart?

Dear Power BI Community

 

I wanted to use a line chart which shows the MonthYear along the X axis and then drill down through a  hiercahy of Division >> Care Group >> Specialty 

 

Is it possible in a line chart to show a trend every month and then drill down through the hierachy?

 

I have tried to pull in the hiercahy into the "Legend" but it only ever shows the top level of the hierachy...Can I only ever do drill down on the Axis?

 

Kind Regards

Helen

 

 

 

2 REPLIES 2
Greg_Deckler
Super User
Super User

@helen_p @Pragati11 is correct. Perhaps small multiples? 


Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...
Pragati11
Super User
Super User

Hi @helen_p ,

 

Yes drill-down is on the X-axis not on the legend.

 

You can vote for this idea here: https://community.powerbi.com/t5/Custom-Visuals-Ideas/drill-down-based-on-legend/idi-p/649432

 

Thanks,

Pragati

Best Regards,

Pragati Jain


MVP logo


LinkedIn | Twitter | Blog YouTube 

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Proud to be a Super User!!

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.