Showing results for 
Search instead for 
Did you mean: 
AdrianaReyna Frequent Visitor
Frequent Visitor

Need Help: Pass values and drilltrought

Hello all!! I have this situation I hope someone could help me.


I have a report that shows information about document number, Banks, accounts, amount, document type, etc.

Then I used the drilltrought functionality and can see the details using filter in drilltrought by HKONE and Amount

For example : When I select the first line in the report and use drilltrought the report of the detail show me the informacion about all the documents with amount 0.32 and HKONE 11301000; everything is correct at this time.



The situation is, that I want to show the number of the document of the first page (summary) like a card or information text in the second page (details).

In the same example, I want to show 10000000006 that is the number of the document shown on the line where we drilltrought in the second page.

This number, I cant send in the filters, because changes the meaning of the report and does not show the information that I'm looking for.

I tried with selectvalue function but I have to have selected the record and I do not want to have to select it, if not only use the drilltrought function and even with the select value function I can not send the value to the details sheet.


I attach the pbix document.


Thanks for your comments!!




ZachMascetta Frequent Visitor
Frequent Visitor

Re: Need Help: Pass values and drilltrought

Hello! Quick question. Is the "Document" field supposed to be summarized by Sum in the table? 

Community Support Team
Community Support Team

Re: Need Help: Pass values and drilltrought

Hi @AdrianaReyna,


Nope, it is impossible.


AFAIK, drillthrough filter can only pass filter value friom specific column, it not support to extract the selected other fields(not in drillthrough filter) from first report page.



Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

For learning resources/Release notes, please visit: | |
AdrianaReyna Frequent Visitor
Frequent Visitor

Re: Need Help: Pass values and drilltrought

Hello!! No isn't summarize by de Document. Thanks for your response
ZachMascetta Frequent Visitor
Frequent Visitor

Re: Need Help: Pass values and drilltrought

I think the issue you are running into with the Document visual is that its currently being treated as a numerical data type, instead of a categorical data type. BI is assuming you want to aggregate the data in some way, instead of just returning the actual value of the document. This is the case with a few of your columns. I think the solution below will get you the results that you want, but let me know how it turns out:


  1. Go to the data view and change the following columns from their current data type to a Text data type: Company, Account, Document. This might cause your visuals to display an error with "Fix It" button. Click the "Fix It" button and the visuals should be all set.
  2. You'll now be able to create a card visual with Document and return a single value. On your "Details" page, add a Card visual and use "Document" as the field. Right click on Document and select "First". This will display your first Document value in the card.

Helpful resources

Community Highlights

Community Highlights

Find out what's new in the Power BI Community!

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 313 members 3,584 guests
Please welcome our newest community members: