Forum Discussion
Resolver IFilter Another Page Based on selected Value in Table
Hi peeps!
I have a table A with Parent ID info in Page1. In Page 2, I have table B with the Child ID info. (1 Parent ID may have many Child ID).
What I wish to do is, when user click on 1 Parent ID in table A, and they click on Page Navigation "View Details" (pink button below), it will redirect them to Page B that would display only information related to selected Parent ID.
Page 1: if user select ib ParentID = ABC1
| Parent ID | Amount |
| ABC1 | 500 |
| ABC2 | 200 |
| View Details |
Page 2: will show breakdown of amount.
| ParentID | ChildID | Amount |
| ABC1 | DEF1 | 200 |
| ABC1 | DEF2 | 300 |
I'm not sure if this is feasible or not in PBI, really appreciate your opinion! If it's not possible, is there other work around I implement?
Thanks sifus!
kilala , You can use drill-through using the button
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-drill-through-buttons
3 Replies
- amitchandak
Super User
kilala , You can use drill-through using the button
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-drill-through-buttons
kilalaThank you so much!
I tried it and it works! Definitely need to learn mor on drillthroug features. Have a blessed day ahead!
Hi, Is drill-through the only option? In other BI tools, the selection passing to another page is the default behavior. It's inconvenient to use Drill-through, as need to assign fields to the drill-through list. Would be good to have this as default. Thanks
