- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

@Syndicate_Admin , You can create slicer on that field/column and that will filter other visuals
Not sure what issue you are facing
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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
Subject | Author | Posted | |
---|---|---|---|
08-12-2024 03:01 AM | |||
07-10-2024 08:08 AM | |||
Anonymous
| 06-17-2024 12:39 AM | ||
04-11-2024 03:11 PM | |||
06-17-2024 08:13 AM |
User | Count |
---|---|
140 | |
110 | |
81 | |
61 | |
46 |