Drill Down by Detail in Line Chart Visual

[MR84]

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?

[amitchandak]

@MR84 , Not very clear.

Can drill through help you?

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-drillthrough

Drill down and up

https://docs.microsoft.com/en-us/power-bi/consumer/end-user-drill

[MR84]

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:

And 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.

[v-yiruan-msft]

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