Forum Discussion
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
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
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/
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!
