Matrix preview drilldown in Dashboard view

[Back2Basics]

Hi

I am creating a dashboard that has several views using the new Matrix Preview vis. The drilldown options work great in the report when using Power BI Desktop, but when I publish and pin to a dashboard the drilldown options and expand data table options are lost. Is there a way to use these when sharing a dashboard, or would people have to do this by using the report view??

TIA

Henry

[v-huizhn-msft]

Hi @Back2Basics,

As i tested, we can still use the drilldown options and expand data table options in Dashboard. In the dashboard screen, you can see all the visualization in one page. You need to click it, you will see it as same in report. Please see the following screenshots. The first displays the dashboard, when I click it, we can see the drill down options.

Please check it based on the steps above.

Best Regards,
Angelia

[Back2Basics]

Hi Angelia

Thank you for your response. But really what you are saying is "no you can't use the drilldown functionality in dashboard, but you can go to the report and view use the functionality there".

I was hoping that there would be a way to utilise the drilldown functionality within the dashobard itself, without the need to move between dashboard and report. What I don't understand is, if the functionality isn't within the dashboard to fully make sure of the visualisations what is the different between the dashboard and the report? It seem bizzare to be able to share a dashboard and not a report when actually the user can still access the report and will have to go into it to view all of the data if they wished to do so.

Is there a way to simpy share a report then, rather than a dashboard - as I think the majority of people that I need to share the dashboard with will constantly be going into the report any way??

[v-huizhn-msft · Accepted solution]

Hi @Back2Basics,

Yes, we are unable to use drill down on dashboard without going to the report. You can create reports over your data model using the tables, columns and visualisation tools. You can't create a dashboard this way. You can pin individual visualisations from a report into a dashboard. whic  like a cockpit of individual visualisations and/or whole reports. Dashboards can have multiple tiles from different reports and different datamodels. You can see the difference dsahbord and report here.

Thanks,
Angelia

[Back2Basics]

Thanks @v-huizhn-msft

I think I understand the differences between the two, I was just hoping to create a 'dashboard' that would have the data collapsed and then users could drill down if necessary. It isn't too much of a problem but if a shame for a visualisation such as the Matrix Preview, as that is beauty of its functionality. I might put this on the ideas board as an 'improvement; for the Matrix Preview.

thanks again

[SwetaS]

Hi

I am creating a dashboard that has several views using the new Matrix Preview vis. The drilldown options work great in the report when using Power BI Desktop, but when I publish and pin to a dashboard the drilldown options and expand data table options are lost. Is there a way to use these when sharing a dashboard, or would people have to do this by using the report view??

REGARDS

Sweta.P.Shimikeri