cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
LGXSteve Frequent Visitor
Frequent Visitor

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

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;

 

Capture.PNG

 

 

 

 

 

 

 

 

 

 

 

 

 

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?

5 REPLIES 5
david2 Regular Visitor
Regular Visitor

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

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 :-)

LGXSteve Frequent Visitor
Frequent Visitor

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

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.

tjd Established Member
Established Member

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

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.

Moderator v-sihou-msft
Moderator

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

@LGXSteve

 

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

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

 

Regards,

LGXSteve Frequent Visitor
Frequent Visitor

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

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

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 6 members 1,233 guests
Please welcome our newest community members: