Forum Discussion
How to drillthrough on Row and Column
Hi,
Just want to know if this is possible or not:
Example:
Matrix in Power BI:
| Rows | Column1 | Column2 | Column3 |
| A | 1 | 2 | 3 |
| B | 4 | 5 | 6 |
| C | 7 | 8 | 9 |
What I need:
When you rightclick on one of the values in the matrix, I want to only see that value in the drillthrough page.
For example, when you use drillthrough on value 5 in the above matrix, I want to see only Column2 in the drillthrough page with value = 5:
| Column 2 | |
| B | 5 |
Is this possible? And if not, what's the best workaround for this scenario?
1 Reply
When you rightclick on one of the values in the matrix, I want to only see that value in the drillthrough page.Drillthroughs are based on table columns, not measures. Please provide a more detailed explanation of what you are aiming to achieve. What have you tried and where are you stuck?
