Clickable graph that takes to a table with filters applied

[some_analyst]

I have a graph which looks like the following:

At this point, I have a tooltip which shows a table if user hovers over any part of the graph. Eg: shows Standard Complexity with At risk = Yes category.

It is difficult for the user to copy the details that pop up, because when mouse moves, the tooltip diappears.

I sthere a way that user can click on any part of the graph and it either shows that selection in a table or in a new page where they can copy parts of the table? 

The table which should come up looks like the tooltip one:

[ribisht17]

Hello @some_analyst 

Yes, there are ways to make the tooltip information more accessible for users in Power BI. Here are some approaches:

1. Drillthrough Pages: You can set up a drillthrough page in your report. When a user clicks on a specific part of the graph, they are taken to a new page that displays detailed information in a table format. This allows users to copy the data easily.

2. Bookmarks and Buttons: Use bookmarks and buttons to create an interactive experience. For example, clicking on a graph element can trigger a bookmark that displays a table with the relevant details.

3. Custom Visuals: Consider using custom visuals that support click interactions. Some third-party visuals available in the Power BI marketplace might offer better functionality for displaying and copying data.

4. Export Data: Allow users to export the underlying data of the graph. They can right-click on the visual and select "Export data" to get the details in an Excel file.

As suggested by Pankaj,1st one is the best option for you , you can get step by step solution here Set up drillthrough in Power BI reports - Power BI | Microsoft Learn

Regards,

Ritesh

Community Champion

Please mark the answer if helpful so that it can help others

Dance-Sing with Data Projects - YouTube

[pankajnamekar25 · Accepted solution]

Hello @some_analyst 

You can use drillthrough 

Set up drillthrough in Power BI reports - Power BI | Microsoft Learn

Thanks,
 Pankaj Namekar | LinkedIn

If this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.