Forum Discussion
Add drill down option in matrxi visual
- 6 months ago
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!
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!