Drill to details (view row-level data)

[riccardomuti]

Whenever I see an aggregated metric (e.g., $483,572 in sales) - in, say, a column in a chart or a cell in a matrix - I should be able not only to drill down to a next level of detail, but to "drill to details" - all the way down to the individual rows of data (e.g., the individual sales orders) that make up that value.

[julianmbs]

Please vote here https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/15332967-enable-see-records-from-matrix-and-table, if you'd like matrix and table to have "See Records" feature. It doesn't look like ideas that have been marked as "Completed" get any attention.

[ande2573]

HOW DO I SELECT THE COLUMN TO SEE RECORDS FROM THE CHART? POWER BI SELECT THE RENDOM COLUMN BY IT SELF WHICH I DON'T WANT TO SEE IN RECORD.

[mjforero]

Hi Friends, I have a dashboard with differentes KPIs and we are using differentes customs visuals, but we need know how to use drilldown from each kpi to each report and from this report we need to do a return to dashboard, if we using the option pin only it works a one report. Could help us if Power BI can to work with this funcionability. Thanks,

[clrkdhdlr]

I can do this in a matrix in Power View but not BI. Am I missing something

[dpou]

Cool. But, is there a feature to see the records deeper behind-behind the visual. For example the data behind that creates the visual. Not the visual and a number. Tableau use this concept where I can drill down to records; exports them and use it in another analysis.

[akruzel]

Adam Kruzel commented · Just Now · Delete I agree that this feature is not complete, especially given that you can't use See Records with measures. Given that it doesn't appear that Completed ideas are given any further consideration, please go here and add your votes so it'll get back on their priority list. https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/15408432-see-records-feature-improvements

[am3]

There should be no limit to the levels of drill down once you drill (1st action) out of the Power BI Top Layer into the tabular layer. From that tabular (which may in itself be aggregates, one should be able to drill down again, and again until you reach the lowest grain. Can this be done in the new version? If so How?

[tas_ranson1]

Yep, definitely not complete. I wish MS would read the details before marking these complete.

[mitul_kantliwal]

We are summarizing raw data into summary table and creating visuals on summary table. Need a way to drill from summarized data to raw data, but currently not possible. This is very critical feature

[ElaW]

we also need to get this row level data. In our case, this ID'S data sits on the SSAS cube but we do not want to expose it to the user since it causing crashes. we only wish to see it in case of drilling down to the row level data. can you update us when this will be available?