Forum Discussion

bzeeblitz's avatar
bzeeblitz
Helper IV
1 year ago
Solved

To view items in table visuals

I have table visuals as below but how do I see the Item number when I click Completed   Date.            Completed. not started 3/17/2025.          3.             0   So when I click Completed 3...
  • Deku's avatar
    1 year ago

    You could add a measure to the tooltip well. When you hover on the row you will see a list of completed items

    completed items =
    CONCATENATEX( 
       CALCULATE(
          VALUES( table[Item Number] )
          ,Table[Status] = "Completed"
       )
       ,table[Item Number]
       ,", "
    )

     

  • bhanu_gautam's avatar
    1 year ago

    bzeeblitz 

    Create a Drill-through Page:

    Add a new page to your Power BI report.
    On this new page, create a table visual that includes the Item number and other relevant details.
    Configure Drill-through:

    Select the new page.
    In the Visualizations pane, find the Drill-through section.
    Drag the field that represents the "Completed" count into the Drill-through filters well.
    Enable Drill-through on the Main Visual:

    Go back to the main page with the summary table visual.
    Ensure that the visual is configured to allow drill-through by right-clicking on the "Completed" count and selecting the drill-through option.
    When you click on the "Completed" count in the main visual, Power BI will navigate to the drill-through page and show the detailed table with the Item numbers filtered based on the selection.