How can I drill down from a chart to a table?

[Anonymous]

I have created a chart that shows the number of tickets opened by an individual for a period of time. I have created a hierarchy from the individual to include the ticket no., and used this hierarchy in my chart.

What I want to be able to do is drill down into my chart, and see a table listing the ticket numbers, and ideally the status of each ticket (status is a known field).

My chart looks like this;

The vertical axis is ticket count. When I drill down on a column I want to be able to list the tickets and their status in a table like ths;

12345 Open

13247 Closed

13299 Closed

Can you do this kind of drill down from one view to another?

[Anonymous]

It looks like tjd has the best suggestion as clearly this is not possible (yet). I have voted for this change though, as it would make a real difference to the reports I can generate.

Thanks

[Anonymous]

Thanks david2. I am not sure if I did quite what you meant, but I right clicked on the chart and chose 'See Data' that shows me the data for that chart. Not what I wanted, but now I think that I am trying to do this the wrong way.

I think another way of expressing what I want is this;

When you drill down on a column, I want a new view(table) filtered by that column. The new table shows different data.

[v-sihou-msft]

@Anonymous

Currenly, in Power BI Desktop, it's not supported to navigate to another visual or report via Drill Througth (like "go to report" Action in SSRS). Please vote ideas below:

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/12863445-enable-user-to-navigate-from-one-power-bi-report-t

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/13715889-drill-to-a-report-page

Regards,

[tjd]

Put a table below your graph that has the fields you want to show and categorize it by your x-axis.  When you then click on one of the columns in the graph, your table will filter to show only those records linked to that column.

[david2]

If you click on the Drill tab on the top, you should be able to see a button named "See Records".  This would show you an overview of the data you want to see. But i'm not sure if it's working with this type of visual - give it a shot 🙂