How to Switch Between Multiple Full Tables (Different Structures) Using a Dropdown Slicer + One Butt

Hi muhammedswaliha ,

If you are refering to a table visualization then you should use field parameters with adittional classification column(s).

• First start by creating your field parameters with all the data in the correct order you need
  In my example the first 3 rows are for sales and the last ones are for cost

• Add a new column to your code with the classification (rename column by double click header)

• Create a table visual and add the parameter on values
• Create the slicer and add category (value 4)

• Change slicer to single select

If you need to have this on a Matrix where the lines are also dynamic you need to have a second parameter table burt be carefull because when you use field parameters in columns and rows at the same time in a matrix everything goes wrong, you can only use row / values or columns/values with field parameters.

You can even have more customization if you add an additional slicer with the parameter values so the user can select within each table the columns and order to see it: