Forum Discussion
Pull Report from Customer Name
i have two pages on my power bi desktop dashboard. one has our crm information and the other has our sales margin information. how do i get my drill thorough to work or pull up sales margin report from clicking on the growers name on the crm page. if click on the customer table i do not get the drill through option
the growers name column needs to be added to the drillthrough fields declaration on the margin page.
3 Replies
- lbendlin
Super User
the growers name column needs to be added to the drillthrough fields declaration on the margin page.
- jbenson
Helper III
That worked great. Thank you for help!
- v-luwang-msft
Community Support
Hi jbenson ,
Power BI drillthrough filter may could help you to get want you want.A Power BI drillthrough filter is used to identify the columns that are to be used to drillthrough from one report page to another report page. Once the columns are selected, using the drillthrough command, the second report page only shows the selected (filtered) data.More details you can see the below:
Power BI Drillthrough Filters and How to Change Them
Create a drill-through button in Power BI
Wish it is helpful for you!
Best Regard
Lucien Wang