To view items in table visuals

[bzeeblitz]

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 and I want to see Item number 

[Deku · Accepted solution]

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 · Accepted solution]

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

[randomUser21 · Accepted solution]

A simple and practical solution is to create a tooltip. I'll leave the information on this link.

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

[bhanu_gautam · Accepted solution]

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

[bzeeblitz]

Awesome, worked 👍 

[bzeeblitz]

Many thanks, can you please show and tell with images

[Deku · Accepted solution]

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]
   ,", "
)