Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
Anonymous
Not applicable

How to use two different date fields in Date range slicer

Hi Experts,

I have two date fields in my dashboard Like created date and credited date, we need user to select date field in the date range filter. I cannot use both filter simultaneously. How to achieve this??

 

Thanks in advance. 

1 REPLY 1
rsaprano
Most Valuable Professional
Most Valuable Professional

Hi @Anonymous 

 

This is a common requirement and there are a couple of ways to achieve this, though for all of these you need to create a date table (e.g. see here for creating one in DAX)

 

Once you have this you have a few options:

 

1) Create two relationships between this date table and your main table on both date fields Only only one can be active (e.g. created date), or both can be inactive. You then need to active the relationship on demand in your DAX Formula using the USERELATIONSHIP function e.g. CALCULATE(COUNTROWS(Sales),USERELATIONSHIP(Date[Date],Sales[Created Date]). See here for details on this function

 

2) Create a copy of the date table by going to modelling -> New Table and setting the new table equal to the original one. One date table can be connected to created date and one to credited date. (This is best if you need to analyse the dates separately e.g. consider all those orders credited in one month which were created in another, though not so much if you want to look at both in a single graph/have the user select only one date range)

 

3) Have a single date table but don't create any relationships between this and the main table. Instead use a function in DAX to create a virtual relationship - e.g. TREATAS (see https://www.sqlbi.com/articles/propagate-filters-using-treatas-in-dax/). 

 

 

 

 

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.