Forum Discussion

vshruti06's avatar
vshruti06
Icon for Advocate IV rankAdvocate IV
10 years ago
Solved

Not able to Navigate user from one Power BI report to another

Hello Everyone,

 

I have a requirement in which I have to create a bar chart which shows employee count with department. When user clicks on the department specific bar it would show the employees name under that department and when the user clicks on the employee name it would open another report with detailed infromation of the employee.

 

Is it possible in power BI? I have tried it with dril down but it is not fulfilling the requirement of navigating user from one report to another. Any other suggestions are also welcome.

 

Regards

Shruti Vyas

  • where the detailed report will be? In powerBI?..

     

    A workaround is to create a table with all employee and a column ( or add a column in the employee's table ) with a link to their detailed report..Then you can add a table in the powerbi report where it will show up only if one emploee is selected and then the user could click this link..

    But that is good when you send them to another external site and of cource you need to have one link for every employee..currently there is no way to filter dynamic the link based on the bar chart selection or open a powerbi report and pass filters in url ( except when use embeded powerbi reports in your web app )

6 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion

    Dashboard tiles have the ability to set custom URL's to transport you from place to place but I am not aware of anything like what you describe, clicking on a bar in a visual and have it transport you to a custom location based upon that selection.

  • konstantinos's avatar
    konstantinos
    Icon for Memorable Member rankMemorable Member

    where the detailed report will be? In powerBI?..

     

    A workaround is to create a table with all employee and a column ( or add a column in the employee's table ) with a link to their detailed report..Then you can add a table in the powerbi report where it will show up only if one emploee is selected and then the user could click this link..

    But that is good when you send them to another external site and of cource you need to have one link for every employee..currently there is no way to filter dynamic the link based on the bar chart selection or open a powerbi report and pass filters in url ( except when use embeded powerbi reports in your web app )

    • vshruti06's avatar
      vshruti06
      Icon for Advocate IV rankAdvocate IV

      Can we expect this feature to be implemented in future?

      • Greg_Deckler's avatar
        Greg_Deckler
        Icon for Community Champion rankCommunity Champion

        vshruti06 - You should check the Ideas area and if this idea is not present, you should submit it and solicit people to vote for the idea. My understanding is that the community plays a significant role (or at least some role) in what new features are released.

    • Sunkari's avatar
      Sunkari
      Icon for Responsive Resident rankResponsive Resident

      We required this functionality. Please let me if you people have any other alternatives for this.