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

Prepping for a Fabric certification exam? Join us for a live prep session with exam experts to learn how to pass the exam. Register now.

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
May PBI 25 Carousel

Power BI Monthly Update - May 2025

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

Notebook Gallery Carousel1

NEW! Community Notebooks Gallery

Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.

May 2025 Monthly Update

Fabric Community Update - May 2025

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

Top Solution Authors