Drill Through on Matrix Fields

[arimoldi]

Hi,

in my report I have a page with a matrix and a page with the details that shows all the row data; when you click on a field in the matrix a button turns on and clicking on it you get redirect to the details page.

The point is that when I click on a field in the matrix the related row data refers to the entire row, not the the field I selected, for example in this case:

	ONGOING	COMPLETED	DELAY	TOTAL
A	1	2	3	6
B	1	1	1	3
C	4	1	2	7

when I click on a 1 I don't get 1 row in the details page but all the total records related to that row.

In the details page I have inserted all the fields used in the matrix in the drill-through area.

Any suggestion?

Thanks,

Andrea

[Anonymous]

Hi @arimoldi 

Can you provide detailed sample pbix file and the results you expect.So that I can help you better. Please remove any sensitive data in advance.

Best Regards,

Jayleny

[selimovd]

Hello @arimoldi ,

you can also click with the right mouse button on a specific cell and then choose the drillthroug.

If you use the button, as far as I know always the whole row is selected.

Would that be an option to you?

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards
Denis

Blog: WhatTheFact.bi
Follow me: twitter.com/DenSelimovic

[arimoldi]

Hi,

I tried also with the right click but the reusult is the same: if I select a cell in the matrix and then I right click on it and then I select drill through I get to the details page where all the rows related to that record are shown, not the single row related to the cell.

Any other ideas?

Thanks,

Andrea