How do I drill down in Power BI Desktop ?

[Youssef_Jaballi]

Hi,i am new in PowerBI and i want know if it is possible to drill down in report by clicking on one  of proprietes in report.For example i create report showing the list of prodcuts by user and when i select user i see another report containig details of selected user.

Thank you for your help

[npatten]

Hi-- I believe you can see the underlying information of a data point in a graph if you right click on the data point and select 'see records'.

https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-april-update-feature-summary/

[Youssef_Jaballi]

yes but is show only records and what i want showe is another report

[npatten]

Can you post of picture of the what you see? And by report, do you mean you would like another PBI report, a new tile/viz, or a new table containing the drill down info?

[Youssef_Jaballi]

yes by report i mean  another PBI report,new tile or a new table containing the drill down info,i just want see another visualtion of data.like for  example the  drill down functionnality in Microsoft Dynamics CRM charts.

[v-qiuyu-msft · Accepted solution]

Hi @Youssef_Jaballi,

Based on my understanding, you want to click one data point in a visual, then pass this data point value to filter another visual or report, and display it, right?

Currently, it's not supported to drill through to another report and pass parameter to filter it. What we can do now is only drill down to detail information in one visual like this: Drill down in a visualization in Power BI. Or create a drill through action in Power BI Service dashboard tile without passing parameter to filter target visual or report, See: Add a hyperlink to a dashboard tile.

Also someone already posted the same requirement in idea forum, you can vote or comment on it, see: PowerBI Reports.

If you have any question, please feel free to ask.

Best Regards,
Qiuyun Yu

[npatten]

You can export the data from a tile into excel and create a new PBI report if you wish. Much of this kind of functionality is described in the PBI website, which I would encourage you to explore. It's a great resource!