Power BI Slicer Filter Another Slicer

Recently, I created a Power BI report using various visualizations, such as a Pie chart, Table, Card, Matrix, and Line chart, as well as Slicers, etc. In that report, I had two slicers: ‘Product Sales’ slicer that has fields such as (Month Name, Product & Profit)and ‘Month Name’ slicer, as shown in the image below.

Now, I want to filter the profit of each product by month in the ‘Product Sales’ slicer, using the value selected in the ‘Month Name’ slicer.

In this tutorial, I will show you how to filter one slicer based on another slicer using Power BI. Additionally, I will explain how to resolve the issue of the slicer not filtering another date slicer in Power BI.

Filter Power BI Slicer Values Based On Another Slicer Using Relationships

Below, I have outlined the steps to filter values in one slicer based on another slicer in Power BI.

1. Open Power BI Desktop and connect the data source.
2. Then, select a Slicer from the Visualizations pane.
3. In the value field, drag and drop the Product, Month Name &Profit from the field pane.
4. Next, you can see the slicer with the given fields on the report view.

5. After that, I will create a table with the Month Names in the Power BI report.

5. Next, I will add another slicer with only the Month Name from the Table data. Drag and drop the Month Name from the data pane to Fields.

Now, we have the two slicers ready. When you click a value in one slicer, it will not filter the other slicer because they do not have any relationship. We need to establish a relationship between these two slicers.

6. Go to the Model view in Power BI Desktop and choose the Manage relationships option.

7. Then, it will open the Edit relationship dialogue box. Under the Cross filter direction, select Both.
8. Then, check the box labeled “Make this relationship active” and click the OK button.

9. In the screenshot below, you can see the relationship between the two directions among the data.

10. Now, click on the report view icon. Selecting the Month Name in the slicer filters the Product sales that occurred in that Month in the product slicer.
11. Below, you can view the screenshot, which will display the Product values based on the Month Name.

Why One Slicer Visual is Not Filtering Other Slicer in Power BI

On to my Power BI report, I have added a ‘Year’ Slicer and a ‘Date’ Slicer. When I select a year value in one slicer, it’s not filtering another slicer that contains a date value along with the year.

However, by default, the slicer visual filters the report when you select a value in the slicer. But it’s not happening when I select ‘Year’ in one slicer.

You can have a look at the screenshot below, which shows the ‘Year’ slicer and ‘Date’ slicer.

Solution:

This is because if you are using the date column and year from two different tables in slicers, then you must establish the relationship between the two tables.

If you are using the date column and year from the single data table, then follow the steps below to resolve the issue.

1. Open the Power BI desktop, and load the data using the Get Data option.
2. Next, select the slicer from the visualizations pane, and drag and drop the Year into the field pane.
3. Next, select another slicer and drag and drop Date into the field pane.

4. Go to the Format tab from the ribbon. Click on the Edit interactions.

5. Next, highlight one slicer by disabling the None icon, and then click on the Filter icon.

Now, you can filter the date slicer by selecting a value in the year slicer.

6. In one slicer, select the year, and you can see the highlighted slicer get filtered with the date up to 09-11-2024.

This is about filtering the slicer values based on another in Power BI.

Although you can filter one slicer’s values based on another in Power BI, I recommend using a single slicer panel with multiple slicers instead of using separate slicers in your report.

You may like the following Power BI tutorials:

• Power BI treemap
• Power BI Slicer Search Box
• Power BI Slicer Buttons
• Power BI ribbon chart

Preeti Sahu

Preeti Sahu is an expert in Power Apps and has over six years of experience working with SharePoint Online and the Power Platform. She is the co-author of Microsoft Power Platform: A Deep Dive book. As a Power Platform developer, she has worked on developing various tools using Power Apps and Power Automate. She also makes Microsoft 365 videos and shares them on YouTube.