How to make two filters using the same column?

Edit Interaction should fix this if you do not have requirements of separate effects of the two filters

https://www.youtube.com/watch?v=5MteQv_h6ck

Otherwise, create a calculated table that duplicates your existing Date Table

Date 2 = 'Date'

And connect one Date table to each fact table, so you have slicers filtering colums of two different tables

If this helped, please consider giving kudos and mark as a solution

mein replies or I'll lose your thread

Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page

Consider voting this Power BI idea

Francesco Bergamaschi

MBA, M.Eng, M.Econ, Professor of BI

Hi EugenioProlog,
You can use the same date field in both slicers and then set appropriate edit interaction.

Click on the slicer, click on Format and then click on Edit Interaction. For the visuals that need filtering, click on filter or highlight on other visual. For the visuals that don't need filtering, click on None on the other visual.

Do the same for 2nd date slicer as well.

Yes, this is 100% possible, but not with a single Date table.

To allow your user to select two different quarters independently, you must use two separate date dimension tables, both pointing to the same fact table.

Create Duplicate Date Tables.

Since a single Date table cannot have two different filter contexts at the same time,

you need to create two role-playing Date tables:

Table Name           Purpose

Calendar_Q1         Slicer for Trimester 1

Calendar_Q2         Slicer for Trimester 2

Both tables are duplicates of your existing Calendar table.

=================================================================

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Jaywant Thorat | MCT | Data Analytics Coach

Linkedin: https://www.linkedin.com/in/jaywantthorat/

Join #MissionPowerBIBharat = https://shorturl.at/5ViW9

#MissionPowerBIBharat

LIVE with Jaywant Thorat from 15 Dec 2025

8 Days | 8 Sessions | 1 hr daily | 100% Free

I've done this before by creating a disconnected (no relationships) calendar table and then creating measures or calculation groups based on the fields from that. I used the same calendar table query to create both tables but this will allow you to create measures that measure different time frames for the same measure types.

Hi EugenioProlog ,

Thank you Anand24 , d_m_LNK , Jaywant-Thorat , FBergamaschi  for your inputs.
I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We are always here to support you.

Regards,
Community Support Team.