Forum Discussion
Not sure what to use - Getting additional information when clicking
Hi,
I am new to Power BI and try to figure out, how I can get more information when I click on counted values in a matrix.
This is my data:
With this I created a simple Power BI report with a matrix:
When I now click on the number "7" from apples, I want to be taken to another page where I can see all the information about these 7 apples from the Excel file (harvester, time harvested, sort) in a table.
How can I achieve this?
I only found tutorials with a drillthrough and an additional button, but I want to be taken to the new view directly when I click the number. I am not even sure the drillthrough is the right approach here or if there is a better option.
I hope you can help me 🙂
Kind regards,
Max
Hii Max_25
Power BI does not support automatic navigation when clicking a value in a Matrix.
A Matrix can only open another page through right-click >> Drill-through.
Left-click or simple click navigation is not available for Matrix values.Drill-through is the correct and only approach for this requirement.
You must right-click the number >> Drill through >> Page 2.
There is no feature to open the detail page automatically on a single click.Below link help you in drill through process :
2 Replies
rohit1991Super User
Hii Max_25
Power BI does not support automatic navigation when clicking a value in a Matrix.
A Matrix can only open another page through right-click >> Drill-through.
Left-click or simple click navigation is not available for Matrix values.Drill-through is the correct and only approach for this requirement.
You must right-click the number >> Drill through >> Page 2.
There is no feature to open the detail page automatically on a single click.Below link help you in drill through process :
Thank you very much for your quick support and the effort you put into it by also re-building it, so it is easier to understand. I really appreciate it 👍
