Forum Discussion
Drill-through report
How do I click on a data item in a visual and be taken to an entirely different dashboard customized to that data item (aka: drill-through report). I saw it in a demo but have found no references online how to do this...
Thank you in advance!
Anonymous Dashboards are your highest level, and can contain tiles from any number of reports.
Dashboards only exist in the Service.
You can pin any visual, from any number of reports, to the same dashboard.
The user will click a "Tile" on the Dashboard, and be taken to a report page.
When you upload a file from the Desktop to the Service, everything exists on the Service (Azure back end). Nothing relates to your on premise desktop file at that point. There are a bunch of different scenerio's for using different back end sources, but we'll keep it simple...
The support documentation is really good, use the navigation on the left hand side of my link to explore these topics further.
Hope that answers your questions/points you in the right direction.
17 Replies
Anonymous There are only 2 drill through type actions at the moment.
1) Clicking a Tile on a dashboard allows you to drill down to a report page which can show the same or completely different visuals. Thus, allowing you to "drill down"
2) There is a drill-down feature that you can enable on several visuals, but it will only drill down to the next level in your heirarchy showing you the data in the same type of visual.
Hi Eno1978,
Thank you for the reply - how do you do #1 (drill to a report page to show the same or completely different visuals)? How do I create this in power bi desktop (and then publish to power bi in the cloud for the users)? I see the arrows on the visuals but those arrows only allow me to do your #2...
Thank you in advance
Anonymous I now understand the confusion.
OK, Power BI has two parts - The Desktop, and the Service.
They have different capabilities.
The Desktop - You can create models and build reports
The Service - You can build reports, and Share
In order to use the "Sharing" capabilities of Power BI you need to pull your PBIX file into the Service, or hit the "Publish" from your Power BI Desktop. When you have done this, you can go to the Service (app.powerbi.com) and pin visuals from the report that you built to a Dashboard. The Dashboard is shared with end users. So when they click on a tile you pinned to the Dashboard, they will be taken to the report page where the visual was pinned from, and be able to see all the other pages of the report you built.
Hello Drill
I found a live demo **bleep** webinar for this hope it will work for you. Here is the webinar description- Live Demo on Advanced powerbi reports using Project Server Data on 25 Oct 2016, 10 AM PT / 1 PM ET. You can now more fully leverage all your project management investments by using Microsoft Power BI for advanced reporting. for more visit here: http://web.advaiya.com/live-demo-advanced-power-bi-reports-project-server-data/?Social=123
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,
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,
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,
