Forum Discussion

nish18_1990's avatar
nish18_1990
Icon for Helper III rankHelper III
1 year ago
Solved

Drill Through report Action

Hi,

 

I have dashboard which has details for the quantity where the created date less than 90 days or more than 90 in a dashboard and i need a new dashbaord as a detailed dashboard which is interactive with the main dashboard . 

 
Derivation Logic for main dashboard KPI:
 
Age_Created = DATEDIFF('Data File'[Created date],TODAY(),DAY)
INC Age Bucket = IF(('Data File'[Age_Created])<=90," <=90",">90")
 

 

 

If i click on the number 928 it should navigate me to next dashboard and show info for sales . and if i click on 446 it should show me information for those categories . Detail dashboard should be like below :

 

 

 

 

DATA:

 

CategorySub CategorySalesQuantity Q2countryCreated date
FurnitureChairs10010China22/05/204
FurnitureTables10020China23/05/2025
AutomobileCars10030China21/01/2025
AutomobileBikes70040China21/03/2025
FurnitureChairs10013India21/01/2025
FurnitureTables50022India21/02/2025
AutomobileCars10054India21/01/2025
AutomobileBikes10060India30/01/2025
FurnitureChairs10030China22/01/2025
FurnitureTables30029China23/05/2025
AutomobileCars20088China21/03/2025
AutomobileBikes10022China21/04/2025
FurnitureChairs50021India12/1/2025
FurnitureTables10033India12/1/2025
AutomobileCars60054India21/01/2025
AutomobileBikes10060India30/01/2025
FurnitureChairs10030China22/01/2025
FurnitureTables10029China23/05/2025
FurnitureSofa10088China21/03/2025
FurnitureBed10022China21/04/2025
FurnitureDining10021India12/1/2025
FurnitureTables10033India12/1/2025
FurnitureTables10054India21/01/2025
FurnitureSofa10060India30/01/2025
AutomobileCars100054India21/04/2025
AutomobileBikes10060India30/06/2025
FurnitureChairs10030China22/07/2025
FurnitureTables20029China23/07/2025
FurnitureSofa10088China21/03/2025
FurnitureBed10022China21/04/2025
FurnitureDining10021India12/1/2025
FurnitureTables40033India12/11/2024
FurnitureTables80054India12/10/2024
FurnitureSofa10060India12/11/2024
  • MFelix's avatar
    MFelix
    1 year ago

    Hi nish18_1990,

     

    Has I refered in my previous post that option is not available on Power BI to drill trough using a single click option, you can have that option using navigation pane or bookmark navigation but for that you would need to do more complex formatting specially the bookmark as some complexity to work properly.

7 Replies

  • Hi  nish18_1990 

    Enable Drill-Through on the Main Page

    • Right-click on the visual showing 928 or 446 (e.g., matrix or chart).
    • Now drag the INC Age Bucket field into the Drill-through filter section in the visualizations pane (bottom-right).

      • This enables drill-through based on this column.

         

         

         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 nish18_1990 ,

     

    For this you need to create the new report page and in the options of the page you need to select the drill trough action, and use the quantity (the one used in the cards) has the drill trough field

     

    Then you need to add the Quantity has a filter on the the matrix on the second page and this will enable the drill trough option on the cards.

     

    You cannot have a click of a button directly on the card to activate the drill trough you can do it by overing over the card and wait a few seconds for the po-up card to appear and then select drill trough.

     

    https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-drillthrough.

     

    See file attach.

    • nish18_1990's avatar
      nish18_1990
      Icon for Helper III rankHelper III

      When i click on the cards its not navigating to next page . If i click on any of the cards below it should filter those values and navigate to next page and show only those details based on card selection

       

      • MFelix's avatar
        MFelix
        Icon for Super User rankSuper User

        Hi nish18_1990,

         

        Has I refered in my previous post that option is not available on Power BI to drill trough using a single click option, you can have that option using navigation pane or bookmark navigation but for that you would need to do more complex formatting specially the bookmark as some complexity to work properly.