Combined filter for different variables

Here's a step-by-step guide:

1. Create a Slicer:

   • Go to the "Visualizations" pane.
   • Click on the "Slicer" visualization to add it to your report canvas.

2. Add the Common Field:

   • Drag the common field (the field you want to filter on, e.g., Car_Color or New_Car_Color) from either table to the slicer.

3. Apply the Slicer to Both Charts:

   • Click on one of your charts.
   • In the "Visualizations" pane, find the field that corresponds to the color (Car_Color or New_Car_Color).
   • Drag this field into the "Filters" pane.
   • Choose the "Basic filtering" option, and then select the slicer you created.

   Repeat these steps for the second chart.

Now, when you select Black or White in the slicer, both charts should update accordingly since they are both filtered by the common field.

If your tables are not related, you might want to create a relationship between them based on the common field. To do this:

1. Go to the "Model" view.
2. Drag the common field from one table to the corresponding field in the other table.

Make sure your tables are related appropriately so that the filter can be propagated across them.

This method assumes that your data model is set up correctly, and there is a relationship between the tables. If there's no relationship, you might need to establish one in the "Model" view by connecting the common field in both tables.