Forum Discussion
Resolver IIDrill Through on Matrix Fields
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
3 Replies
- selimovd
Most Valuable Professional
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
arimoldiHi,
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
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
