Combined filter for different variables

[Anonymous]

Hi all, 

I have two charts. In my first chart I have a Car_Color variable that I want to filter on, and it has the values Black and White. In the second chart I have another variable called New_Car_Color and it also has values Black and White.

I want to create a filter to be able to filter both of the charts at the same time. To filter should have the values Black and White, and it should filter both of the charts. How can I achieve this?

My variables are in different tables.

Thanks

[123abc · Accepted solution]

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.