Forum Discussion

Back2Basics's avatar
Back2Basics
Icon for Resolver I rankResolver I
9 years ago
Solved

Matrix preview drilldown in Dashboard view

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

Need Help
  • v-huizhn-msft's avatar
    v-huizhn-msft
    9 years ago

    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

5 Replies

  • v-huizhn-msft's avatar
    v-huizhn-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    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's avatar
      Back2Basics
      Icon for Resolver I rankResolver I
      9 years ago

      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's avatar
        v-huizhn-msft
        Icon for Microsoft Employee rankMicrosoft Employee
        9 years ago

        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