Pull Report from Customer Name

[jbenson]

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 

[v-luwang-msft]

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

[lbendlin · Accepted solution]

the growers name column needs to be added to the drillthrough fields declaration on the margin page.

[jbenson]

That worked great. Thank you for help!