Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
4 years ago
Solved

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 f...
  • Anonymous's avatar
    Anonymous
    4 years ago

    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.

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
4 years ago

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's avatar
Anonymous
Not applicable
4 years ago

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.