cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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 :-)

Highlighted
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
GregDeckler

How to Get Your Question Answered Quickly

Power BI Super User, Greg Deckler, explains

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Ideas
Users Online
Currently online: 44 members 1,084 guests
Please welcome our newest community members: