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!!
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.
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:
- 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.
- 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.