how to create a table with dynamic rows based on visual?

[ppgandhi11]

Hi,

I am using bunch of measures etc. in my matrix visual. I am also using a filter and drill through on this page. Now, I want to create a dynamic table (or the table structure can be static but the rows will need to be dynamically inserted) based on the filter used on the page. Is it possible to do so in power bi?

scenario:

on page 1, I have  a filter called service. I am doing drill through on page 1 that takes me to page 2 based on providerID with service filter in place. On page 2, I want to list all the providers that are applicable for this filter. I am trying to create a dynamic table that will have all the list of such providers.

Thanks.

[Greg_Deckler]

Tough to say exactly but you should be able to just create a table visual on page 2 and put your provider column there. The drill through filters should filter that table down to the appropriate providers.

[ppgandhi11]

That is exactly what I do not want.

Let say there were total 10 providers to begin with on page1. When the service filter on page1 is selected, let say only 8 providers show up because of this filter on page 1.

Now when I drill through on page 1 to one of the providers, it will take me to page 2 that has info for only this provider. I am carrying the service filter as well on the 2nd page.

What I want on 2nd page is: ALL the eligible providers applicable for service filter that I carried. (so basically 8 of them that I saw on page 1). There is a business reason to do so.  I need a drill through but i need info for all the providers as well. Is there a way to access it?

That is why I was looking at creating a dynamic table on page 2 with all the providers for the service. 

Alternatively, I can collect this list of providers on page 1 itself. Is there any way to pass this list to 2nd page?