Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
mthumukunta
Frequent Visitor

Show selected row in Paginated report

I am using Power BI Paginated reports to display a table. My records are grouped based on a date field. I need to be able to just display the table for that date when the user clicks on that date. For instance, my table initially is as follows: 

mthumukunta_0-1694020784849.png

When the user clicks on the date : 9/5/2023, I want the report to only display that date, in this case, the first record like follows:

mthumukunta_1-1694020853468.png

How do I achieve this in Power BI Report Builder? 

1 REPLY 1
d_gosbell
Super User
Super User

You could probably create a drillthrough link on the date that would either filter the first report for the selected date or would pass the date parameter to a second report. see Drillthrough reports in a paginated report - Microsoft Report Builder & Power BI Report Builder | Mi...

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.