cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
lmundia Frequent Visitor
Frequent Visitor

table navigation

I have a request to provide a table in PowerBI that allows users to navigate to other pages. I have tried to use hyperlink but that didnt work for me. Below is a watered down version of what I am trying to accomplish, my main table will have hundreds of items and want an ability to click on location and have the report navigate to another report using the clicked value as a filter. 

 

Main Table

 

Location

Revenue

Cost

Profit

New Orleans

300000

230120

69880

Knoxville

412000

320412

91588

Nashville

321343

231400

89943

 

Detailed Report (When a Location is Clicked, navigates to a different page)

Detailed Report for New Orleans

Category

Quantity

Internal Cost

Sub Contract Cost

Variance

Polyamide

500

68

12

60%

Polyester resins

324

43

34

32%

Polyethylene

213

32

13

10%

Polypropylene

432

43

23

13%

Polysulfides

403

90

41

9%

 

Thank you in advance

1 ACCEPTED SOLUTION

Accepted Solutions
lmundia Frequent Visitor
Frequent Visitor

Re: table navigation

Actually PowerBI just introduced this feature in the new Matrix visual which is still in preview mode. I have tested it and it works like a champ. The only downside that I have seen thus far is you can't have two fields in the row headers but can easily be resolved by concatenating your fields. The feature instruction are here https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-matrix-visual/

 

3 REPLIES 3
Moderator v-sihou-msft
Moderator

Re: table navigation

@lmundia

 

Currently, Power BI Desktop doesn't support navigation page feature (like "go to report" action in SSRS). Please submit a feature request on idea.

 

Regards,

lmundia Frequent Visitor
Frequent Visitor

Re: table navigation

Actually PowerBI just introduced this feature in the new Matrix visual which is still in preview mode. I have tested it and it works like a champ. The only downside that I have seen thus far is you can't have two fields in the row headers but can easily be resolved by concatenating your fields. The feature instruction are here https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-matrix-visual/

 

j_kalyani Frequent Visitor
Frequent Visitor

Re: table navigation

Hi. I searched the link ( https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-matrix-visual/) for this issue but there is no solution for this problem. Can you please check and again give the correct link? Thanks!