Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

URL Action - Open in same window

Hello, 

 

Could you please answer the following: I'm currently working on Employee Attendance Tracking workbook.

While building the Home Page, I added the employees pictures so when the manager will click on a certain one, it will redirect him to Employee details dashboard. The method used is using the bookmaks (on each employee dashoard). 

The problem is that the manager wants to have only 2 dashboards in the report - the 1st is the Home page that contains the pictures and the 2nd one is the Employee details - How can i do that using URL Action and open the URL in the same window when a picture is selected.

 

Thank you in advance,

 

Rita.

Need Help
  • v-alq-msft's avatar
    v-alq-msft
    6 years ago

    Hi, Anonymous 

     

    I'd like to suggest you use URL filters to filter the result page. For further information, you may refer to the article . Here is my sample data.

     

    You may copy the link and append at the end of link as follows.

     

    .../ReportSection?filter=Products/UnitPrice eq 18
.../ReportSection?filter=Products/UnitPrice eq 30
.../ReportSection?filter=Products/ProductID eq 40

     

     

    Then you could make the image selected, go to 'Format image', click 'Action', set 'Type'  as 'Web URL' and 'Web URL' as the corresponding link. 

     

    When it is saved and published to service, you can click the image and it will go to the result page filtered by URL parameters. Here are the results.

     

     

    Best Regards

    Allan

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

8 Replies

  • v-alq-msft's avatar
    v-alq-msft
    Community Support
    6 years ago

    Hi, Anonymous 


    Based on your description, I created data to reproduce your scenario.

    Table:

     

    You may create three bookmarks on Detailed pages and apply the corresponding visual level filter  to the visual.

     

    Then you may make the corresponding image selected, go to 'Format image', click 'Action', set 'Type' as 'Bookmark' and 'Bookmark' as the specific bookmark.

     

    Finally when you ctrl+click the image it will go to the specific bookmark of Detailed page.

     

    Best Regards

    Allan

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hello v-alq-msft ,

       

      Thank you for your reply, I appreciate.

       

      Hence, the current problem is that the manager doesn't want the bookmarks Method but the URL Method: 

      I copied the URL of the "Report details" from powerbi service and added a filter to it as the following: 

      URL of report details: https://app.powerbi.com/groups/52131e3d-7c2d-4fd4-962f-a4c84f49ea35/reports/a5f2faa8-76f4-401b-a037-5bee1295997e/ReportSection724bb01bf5b90ad5a4c1

      Employee Page :https://app.powerbi.com/groups/52131e3d-7c2d-4fd4-962f-a4c84f49ea35/reports/a5f2faa8-76f4-401b-a037-5bee1295997e/ReportSection724bb01bf5b90ad5a4c1?filter=Union~2FName-ID%20eq%20%27Caren%20ABBOUD%20-%203%27

      So when the manager will click on an employee image it will redirect him to the above link.

      How can i open this link in the same window?

       

      Thank you in advance,

       

      Rita.

       

       

      • v-alq-msft's avatar
        v-alq-msft
        Community Support
        6 years ago

        Hi, Anonymous 

         

        I'd like to suggest you use URL filters to filter the result page. For further information, you may refer to the article . Here is my sample data.

         

        You may copy the link and append at the end of link as follows.

         

        .../ReportSection?filter=Products/UnitPrice eq 18
.../ReportSection?filter=Products/UnitPrice eq 30
.../ReportSection?filter=Products/ProductID eq 40

         

         

        Then you could make the image selected, go to 'Format image', click 'Action', set 'Type'  as 'Web URL' and 'Web URL' as the corresponding link. 

         

        When it is saved and published to service, you can click the image and it will go to the result page filtered by URL parameters. Here are the results.

         

         

        Best Regards

        Allan

         

        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hello All,

     

    Does any solution identified to show the filtered results in the same tab of browser instead of new tab?

     

    I need the solution where I had 3 filters and a table with same 3 colums filtering the data based on the value selected by user in 3 filters by using button with action type as weburl.So, whenever user clicks on search button,the filtered results were opening in new tab of browser.

    I need to show the filtered results always in same tab.

     

    used the below measure to the action type of button.

    Measuretest = "https://app.powerbi.com/groups/.........ReportSection?filter=Basic/Pro in ('"&[Measure Pro]&"') and Basic/Pro1 in ('"&[Measure Pro1]&"') and Basic/Project in ('"&[Measure Project]&"') and Basic/PersonnelName in ('"&[Measure Per Name]&"')"
    Ex: Measure Pro will hold the user selected value with 
    = CALCULATE(CONCATENATEX(VALUES(Basic[Pro]), [Pro], "','"), ALLSELECTED(Basic[Pro]))
     

    After clicking the CLICK ME button the below table should filter within the same tab of browser.

     

  • jestelrod's avatar
    jestelrod
    Regular Visitor
    3 years ago

    Has anyone found the solution to open the URL from the same browser tab?