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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

How to provide users with list of ID's that are aggregated in visual?

I'm pretty new to Power BI and recently demo'd some dashboards to our internal users. The data is pretty simple and consists of data similar to below.

 

The users would like to be able to see the sales_ID's that are aggregated to the count of sales or the total revenue.

 

I've been unsuccessfully trying to set up drill down and drill through. Can anyone help with a solution?

 

1.PNG

2 REPLIES 2
GilbertQ
Super User
Super User

Hi @Anonymous 

 

You would need to create another report page and then add in the drill through filters?

 

Set up drillthrough in Power BI reports - Power BI | Microsoft Learn





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Anonymous
Not applicable

Hi @GilbertQ ,

 

Thanks so much. I've done a quick trial and this is getting me in the right direction. I'll still need to dive into this more to see if it fully covers my requirements.

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

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