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
Syndicate_Admin
Administrator
Administrator

Change data in a table according to filter

Having a single table, I would like the data to change according to the filter that is applied, for example if it is filtered by cars I want it to show me the data of the cars table and if I change filter to trucks that shows the respective data, but all using the same table to show. Any idea of how it could be realized?

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi @Dread ,

 

Since table 1 and table 2 have the same column names, why not try to append the two tables in Power Query?

Append queries - Power Query | Microsoft Docs

After appending into one table, you can use the filter in the new table to filter.

 

Best Regards,

Stephen Tao

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
amitchandak
Super User
Super User

@Syndicate_Admin , You can create slicer on that field/column and that will filter other visuals

 

Not sure what issue you are facing

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

I have two tables, they have exactly the same columns and using a single panel (the same for both tables) I would like to exchange the data shown between Table1 and Table2 using a checkbox or something like that.

Anonymous
Not applicable

Hi @Dread ,

 

Since table 1 and table 2 have the same column names, why not try to append the two tables in Power Query?

Append queries - Power Query | Microsoft Docs

After appending into one table, you can use the filter in the new table to filter.

 

Best Regards,

Stephen Tao

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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.