Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
Solved! Go to 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
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 @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
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
@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
User | Count |
---|---|
89 | |
85 | |
66 | |
62 | |
57 |
User | Count |
---|---|
138 | |
112 | |
94 | |
82 | |
71 |