Forum Discussion
Hyperlink in table data to nevigate
Hi Team,
I am new to Power BI. I need your help in below scenario, kindly help me.
I have one table which are having below shown data,
| Product_ID | Product_Name | Price | BOM | Available | End_Of_Support | End_Of_Life |
| 1001 | A1001 | $50 | Yes | Yes | 30-Dec-18 | 31-Mar-19 |
| 1002 | B1002 | $75 | Yes | No | 15-Feb-18 | 30-Jun-18 |
| 1003 | C1003 | $100 | No | Yes | 10-Jan-19 | 5-Apr-19 |
| 1004 | D1004 | $50 | Yes | Yes | 15-Aug-18 | 26-Jan-19 |
| 1005 | E1005 | $200 | No | Yes | 25-Dec-18 | 1-Jan-19 |
I have loaded this table data in Power BI and used table chart on myfirst page of report I am showing few columns as below,
| Product_ID | Product_Name | BOM |
| 1001 | A1001 | Yes |
| 1002 | B1002 | Yes |
| 1003 | C1003 | No |
| 1004 | D1004 | Yes |
| 1005 | E1005 | No |
I need the data for column "Product_Name" should have hyperlink and if I select B1002 then it should display below data
| Price | End_Of_Support | End_Of_Life |
| $75 | 15-Feb-18 | 30-Jun-18 |
If I click on E1005 product then it should show below data and so on
| Price | End_Of_Support | End_Of_Life |
| $200 | 25-Dec-18 | 1-Jan-19 |
There are more than 10K records in my table. Please help me to resolve this scenario.
Regards,
Abhi
4 Replies
Hi Anonymous,
Current power bi not contain feature as you mentioned, I'd like to suggest you use Product_Name to create a slicer to achieve your requirement.
Steps:1. Use product_name to create slicer.
2. Build a table visual with price, End_of_Support and End_of_File.
3. Filter on slicer to achieve filter effect.
Regards,Xiaoxin Sheng
Hi Anonymous,
Thanks for the reply. I was wondering to use slicer as I would be having thousands of product names and then in that case it will not be a good idea to use it.
I heard there is somthing bookmark which could help but not sure how.
Do you think bookmark can be helpful in this case?
Regards,
Abhi
Hi Anonymous,
Bookmark feature means save current page and filter effect as bookmark, then you can click on bookmark to quick restore stored visual and slicer status.
For e.g:
You create a 'product A' bookmark which setting to store filtered 'product A' records.
Next time you need to check 'product A', you can simply click on that bookmark to restore previous 'product A' filter effect.I don't think this feature is such suitable for your scenario.
In my opinion, I'd like to suggest you add columns to group your product as different categories, then use these categories as parent filters to cut down product name amount.(quick lookup effect)
Regards,
Xiaoxin Sheng