For each point in the Power BI line graph, is there any drill-through option available?

[I42006]

For each point in the Power BI line graph, is there any drill-through option available?

In each point of the line chart, there is an 'Analyze' option. Is it editable?

In a line graph, for instance, there is an increase in amount. So I need to list out the reasons for the increase. Sometimes it may decrease. So the requirement is that at each point, drill through through action, it will show the reasons.

[Anonymous · Accepted solution]

Hi @I42006 ,

Based on the information you provided, you need to note that only data with a hierarchical structure (e.g., year, month, and day) can be drilled down.
As you mentioned, Power BI provides a feature for analysing increases or decreases in line chart data points.Power BI uses machine learning algorithms to identify and interpret fluctuations. It examines the different columns and identifies those factors that show the greatest change in relative contribution, ranking the insights shown first by the most important contributors. It is not editable.

This feature is a powerful tool for understanding the reasons behind data trends. You can learn about its usage as well as limitations at the following two links:

Use the Analyze feature to explain fluctuations in report visuals - Power BI | Microsoft Learn

Use insights to explain increases and decreases in visuals - Power BI | Microsoft Learn

You can add bookmarks as a workaround, set corresponding buttons for the points of the line graph, and display your desired results with text when clicked. You can refer to the link below for more details on setting up bookmarks:
Create report bookmarks in Power BI to share insights and build stories - Power BI | Microsoft Learn

Best Regards,

Ada Wang

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