Hyperlink in table data to nevigate

[Anonymous]

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

[v-shex-msft]

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

[Anonymous]

Hi @v-shex-msft,

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

[v-shex-msft]

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

[Anonymous · Accepted solution]

@v-shex-msft, Thanks for reply.

It is a good feature to use but unformtunaly for my requirement it wont fulfil.

Rather I think I could use drill through feature which could somehow manage to fulfil it, with perticular product name it will filter and drill through me on other page.

Regards,

Abhi