Forum Discussion

dikssha's avatar
dikssha
Regular Visitor
6 months ago
Solved

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 P...
  • grazitti_sapna's avatar
    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!