table navigation

[lmundia]

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

[lmundia · Accepted solution]

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/

[Anonymous]

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!

[v-sihou-msft]

@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,