The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
HI , i have one question, let's see we have 50 or more projects in different sector, then is it possible that first we make a filter by Sector and then in that sector available project will appear in Table or Matrix and in each project have bookmark in front of project , and then can do navigation for that project from bookmark. like in below table, there are two sectors, and if i click project & implemention sector then apprear respective projects and from there can do page navigation or insert bookmark in table or matrix etc or etc?
Sector Projects
Projects and Implementation Project A
Data and Decision Support Project B
Projects and Implementation Project C
Projects and Implementation Project D
Projects and Implementation Project E
Data and Decision Support Project F
Ye it's possible. You can use drillthrough concept for navigating between pages. Please follow the below steps.
1) Initial represntation of charts will looks like below
2) If i click on Projetcs and implementation column then it can filters the what are the projects belongs to this in matrix chart.
3) Next open a new page and use the same matrix table there. Now got to expand Page Information->Click on page type dropdown and select drill through as shown in below snap.
then it will ask from which filed do you want to drillthrough as shown in below snap,
4) Now you can add projects column here.
5) Now go to your main page where column chart and matrix chart we have then right clik on any projetc name and select drill through field then select the page which do you want to navigate(in my case it is page 7)
6) Now if you see, automatically it navigated to Page 7 and it showing only Project C related data
I hope now you are clear.
Please let me know if it works!
Thanks!
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
what is the business problem you are trying to address?
upon selecting sectors, projects will appear on table, then from i need to click on project name and it should take me to another respective page , is it possible?