Forum Discussion
Refer to the table selected in drop down list
I am stuck with a problem here,
I have multiple tables in my data, now I want to create one dashboard in which I want to add a drop-down slicer so that on selecting any of the table names in the drop-down list it shows the data from that table.
Suppose I have Tables: Table A, Table B, Table C, and Table D
So it should show dynamically the data of the selected value in the drop down.
| Dropdown | ||||||
| Table A | Table B | |||||
| Table B (selected) | Title | Start Date | End Date | Comments | ||
| Table C | - | - | - | - | ||
| Table D | - | - | - | - |
Hi tiwari_456 ,
You can make bookmarks to accomplish this, please refer to the steps below.
You need to create a bookmark for each form:Then attach a button to each bookmark:
Change the display of different tables by clicking on the buttons.
You can refer to the replies in this thread for the exact steps:
Solved: chart type change on published bookmarks - Microsoft Fabric Community
Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
- Idrissshatila
Super User
Hello tiwari_456 ,
you could use field parameters adding all the values from all the tables then adding a category to group the values of each table under the table name.
check this out https://youtu.be/nWgPynP9XDM?si=9Pf2iq35PKmh3N0T
Hi tiwari_456 ,
You can make bookmarks to accomplish this, please refer to the steps below.
You need to create a bookmark for each form:Then attach a button to each bookmark:
Change the display of different tables by clicking on the buttons.
You can refer to the replies in this thread for the exact steps:
Solved: chart type change on published bookmarks - Microsoft Fabric Community
Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
