Skip to main content

    Power BI

    New

    Drill Down with Field Choice

    Vote (2) Share
    's profile image

    on 09 Jun 2017 20:39:44

    I have a Sales Report showing Column DivisionName, MonthName. Data Value as SalesValue.
    I want to drill down Division to next level by ProductCategory or Product or Country Level. This drill down choice is for user to decide. How Can we achieve this.

    Comments (2)
    's profile image Profile Picture

    99e2010f 72fb-48cf-8d4d-0c39da5fb302 on 05 Jul 2020 23:26:21

    RE: Drill Down with Field Choice

    We would like to drill into data, all the way in to the sales order.

    's profile image Profile Picture

    5ff148c5 dfec-4ef1-a13f-646a92c4c567 on 05 Jul 2020 23:17:27

    RE: Drill Down with Field Choice

    I would set up multiple matrix visuals on the same page. Matrix 1 = Division; Matrix 2 = Products Category; Matrix 3 = Product; Matrix 4 = Country. Then when they click on a division they will see a summary of each of the matrix info for 2-4. Or use the drill through feature for pages of each.