Showing results for 
Search instead for 
Did you mean: 

Filter two columns using the same slicer

I hope you can make me understand well.

I have the following table that annex, from which I want to get two tables based on the same slicer

A table where leader 1 is the leader (this is easy)

A table where leader one is the CoLeader.

The trick is that it is filtered with the same slicer.

I do the example in Excel but I really want the exercise with DAXEjemplo.png


Thank you! Worked! However, I still need to be able to do it with DAX, more exactly with some formula of contains.

Super User
Super User

Hi there @KatheB 

If you are creating visuals in Power BI, I would actually suggest using the "Sync separate slicers" method:


I have attached a sample PBIX to illustrate.

The steps I followed were:

  1. Load your table shown above (I called it Data)
  2. Optional: Create Lider and Co Lider dimension tables, related to the corresponding columns of Data table.
  3. Create the two table visuals
  4. Add a slicer using column Lider[Lider].
  5. Add a second slicer using column 'Co Lider'[Co Lider]
  6. Edit Interactions so that the Lider slicer just filters the first table, and the Co Lider slicer just filters the second table.
  7. Open the Sync Slicers pane (View > Sync Slicers).
  8. For each of the two slicers, select it, then in the Sync Slicers pane under "Advanced options" enter a name (I used "LiderSlicers") and leave the two boxes ticked (picture below).
  9. Hide the Co Lider slicer.
  10. Now, the filter on the Lider slicer will effectively filter Lider for the first table and Co Lider for the second table.

It is possible to use a DAX-based approach, but I consider this solution a bit tidier. Will this work for you?


If you are creating visuals in another tool based on a Power BI dataset, you may need a DAX-based approach.







Owen Auger
Did I answer your question? Mark my post as a solution!

Helpful resources

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors