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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
MR84
Frequent Visitor

Drill Down by Detail in Line Chart Visual

Hi,

 

Very new to the power platform so trying to find my feet. 

 

I have a line chart visual showing months of the year and a legend per year. At month level this is great and i can compare the two trends, however when i use the Drill Down feature and click on one of the months i get the data from each year in the legend. 

 

Is there anyway to just click on a certain detail to get the Drill Down from there on a visual?

3 REPLIES 3
amitchandak
Super User
Super User

Hi @amitchandak Thank you for your response.

 

The Drill Through feature is a possibilty however my understanding is I would need to setup a new report for each month.

 

The Drill Down feature is the feature I have used at the moment however it drills down on both years data and presents that rather than say Feb of 2021. It shows the data from Feb 2021 and 2020. 

 

Hopefully a visiual of what i'm working with clears this up. 

 

So this is showing the totals of each month comparing 2 Years:

(1).pngAnd here I have selected the Feb 2021 Drill Down and its showing data from both years. I'm wondering if there is an easy way to just show the selection I have made rather than going down the Drill Through option.(2).png

Hi @MR84 ,

Please review the content in the following links, hope it can help you.

Customize tooltips in Power BI Desktop (use tooltips)

Use ‘report page tooltips’ to provide details (create tooltips page)

How to show the detailed information on label, when user click on particular bar?  (create another table or card to display detailed info)

Best Regards

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.