Forum Discussion
Add drill down option in matrxi visual
I have 2 page- Main, Detailed. Main has a matrix visual with 3 columns- Project name, Start year and Capacity. Detailed page has information of the project and has been set as drillthrough based on Project name. So, if use will right click on any project in the Main page visual and select drill through then Detailed page will show all the information for that particular project.
I want to make it clickable so that instead of right click and then select drill through, user use click on a project in the the Main page visual and Deatiled page show the information.
Hi dikssha,
In Microsoft Power BI, drillthrough from a matrix/table always requires right-click by default. Direct left-click navigation from a row is not supported natively.
You can alternatively do below to achieve this
Add a button on home page
set action on
Set Type to Drill through
Set Destination to detailed page
New when user selects a project and hit this button he'll be directed to detailed page view.
Alternatively, you can add adetailed column in matrix
Set Conditional formatting to Web URL
And create a dynamic link to detailed page like below
Project URL =
"https://app.powerbi.com/groups/me/reports/ReportID/ReportSection?filter=Table/ProjectName eq '"
& SELECTEDVALUE(Table[Project Name]) & "'"Now when the user selects a row and hit details link, user will be redirected to the detailed page
🌟 I hope this solution helps you unlock your Power BI potential! If you found it helpful, click 'Mark as Solution' to guide others toward the answers they need.
đź’ˇ Love the effort? Drop the kudos! Your appreciation fuels community spirit and innovation.
🎖 As a proud SuperUser and Microsoft Partner, we’re here to empower your data journey and the Power BI Community at large.
đź”— Curious to explore more? [Discover here].
Let’s keep building smarter solutions together!
2 Replies
- grazitti_sapna
Super User
Hi dikssha,
In Microsoft Power BI, drillthrough from a matrix/table always requires right-click by default. Direct left-click navigation from a row is not supported natively.
You can alternatively do below to achieve this
Add a button on home page
set action on
Set Type to Drill through
Set Destination to detailed page
New when user selects a project and hit this button he'll be directed to detailed page view.
Alternatively, you can add adetailed column in matrix
Set Conditional formatting to Web URL
And create a dynamic link to detailed page like below
Project URL =
"https://app.powerbi.com/groups/me/reports/ReportID/ReportSection?filter=Table/ProjectName eq '"
& SELECTEDVALUE(Table[Project Name]) & "'"Now when the user selects a row and hit details link, user will be redirected to the detailed page
🌟 I hope this solution helps you unlock your Power BI potential! If you found it helpful, click 'Mark as Solution' to guide others toward the answers they need.
đź’ˇ Love the effort? Drop the kudos! Your appreciation fuels community spirit and innovation.
🎖 As a proud SuperUser and Microsoft Partner, we’re here to empower your data journey and the Power BI Community at large.
đź”— Curious to explore more? [Discover here].
Let’s keep building smarter solutions together! - cengizhanarslan
Power BI doesn’t support “single left-click = drillthrough” on a Matrix out of the box. Left click is reserved for cross-filtering/highlighting, so drillthrough is intentionally on the right-click context menu. As an alternative you could:
-
On the Main page, insert a Button (Blank or Navigator).
-
Set Action = Drill through
-
Set Destination = Detailed
-
Keep “Maintain filters” on, if you want slicers to carry over.
-
