Forum Discussion

jbenson's avatar
jbenson
Icon for Helper III rankHelper III
5 years ago
Solved

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

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

  • v-luwang-msft's avatar
    v-luwang-msft
    Icon for Community Support rankCommunity 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