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!
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.