Forum Discussion

Lakshmiramesh's avatar
Lakshmiramesh
Regular Visitor
2 years ago
Solved

Page navigation in table Visualization

Hej,

 

I have simple table visual. Need to have one column as a hyperlink like excel. and click the cell value need to go to required page.

Excel looks like

 

 

Step 1 :Take this data in Powerbi: 

  • But not able to set the hyperlink as same as excel.

Step 2: Have lot of pages with table visual.

When to click the table item ,need to go to that page. like click on 8.5,it has to go page named as 8,5.

 

Thanks in advance

  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Lakshmiramesh 

     

    When import the excel tables, you should add a new urls columns about the hyperlinks because Power BI can't read out hyperlinks directly.

    You use Power BI Desktop to add hyperlinks (URLs) to a semantic model. You can add those hyperlinks to your report tables and matrixes in either Power BI Desktop or the Power BI service. Then you can display the URL or a link icon, or format another column as link text. When report readers select a link, it opens in another browser page.

    Here is the link for your reference:

    Add hyperlinks (URLs) to a table or matrix - Power BI | Microsoft Learn

     

    Best Regards

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

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Lakshmiramesh 

     

    When import the excel tables, you should add a new urls columns about the hyperlinks because Power BI can't read out hyperlinks directly.

    You use Power BI Desktop to add hyperlinks (URLs) to a semantic model. You can add those hyperlinks to your report tables and matrixes in either Power BI Desktop or the Power BI service. Then you can display the URL or a link icon, or format another column as link text. When report readers select a link, it opens in another browser page.

    Here is the link for your reference:

    Add hyperlinks (URLs) to a table or matrix - Power BI | Microsoft Learn

     

    Best Regards

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