I have some KPIs set up as Card visualisations, with the results being a COUNTROWS measure based on a SQL query. Is there any way to see from this the rows that the query produces? I know I could use the Edit Queries feature, but I was hoping for something based within the dashboard itself.
After my research, I'm afraid it couldn't achieve in Power BI for now.
and you may try to use Drill through function in your report.
Assume we have two reports, A and B. we set the B as the focused page. we can right-click on a data point in A and drillthrough to B to get details that are filtered to that context.
So you could do one or more pages report for the detailed information set drill through for it.
For your requirement, you could post your new idea in Power BI ideas and make this feature coming sooner.