Forum Discussion
To view items in table visuals
- 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] ,", " ) - 1 year ago
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. - 1 year ago
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
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