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

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

Reply
Bernard_yu
New Member

Retrieve all record of a filtered table (visual) in another table (visual)

Hello,

I'm working with dataset with a main table of 2 millions of rows and couple dimensions
Let's consider that these 2 millions rows are in fact 250k articles but in different states/date/... . Around 8 variations per articles thus 2 millions rows in total. Most variations are in the main table, some others are in dimensions.

I have a view where I filter by year with a slicer, for example for 2022, I obtain 2000 rows and maybe around 250 disctinct articles.

Now, I need a table with all records (all states/dates) of these 250 articles. I can't manage to retrieve the list of articles obtained after applying all my slicers.
In my example I slice by date, but I can slice on others variables too.

Any way to obtain this ?

Thanks for your help.

1 REPLY 1
Bernard_yu
New Member

Anyone has any idea on this topic ?

Since I import my data, I can easily create/modify tables.

Thanks for your help

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

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