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

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
Anonymous
Not applicable

One date slicer from several queries/fields

Hello,

I have a Power BI report with three visuals that I'd like to apply one date slicer to.

The three visuals are populated by three separate fields/queries and each of these have a date column which display dates but these dates are different in each as they cover different stages of the project.

Is it possible to create a date slicer from these three different date ranges and apply it to the three visuals? 

Many thanks.

 

 

1 ACCEPTED SOLUTION
AndrewPF
Helper V
Helper V

In Power Query, create a new date "Fact Table" from the three original tables, which contains only date (deduped). 

Go back to Desktop, Model View, and set up relationships between the Fact Table and each of the three other tables. 

Create a date slicer using the new Fact Table. 

Providing the interactions are correct on your report tile, selecting a date from the new slicer should update everything else. 

View solution in original post

4 REPLIES 4
AndrewPF
Helper V
Helper V

I think they can have different names. 

Anonymous
Not applicable

Thanks, yes I'm just starting now and seems to let me link them regardless of title. 

Anonymous
Not applicable

Thanks @AndrewPF 

 

When I go to set up the relationships, do the date columns need to be the same name across all of the tables to be connected or can I link date columns regardless of their names? 

Thanks

AndrewPF
Helper V
Helper V

In Power Query, create a new date "Fact Table" from the three original tables, which contains only date (deduped). 

Go back to Desktop, Model View, and set up relationships between the Fact Table and each of the three other tables. 

Create a date slicer using the new Fact Table. 

Providing the interactions are correct on your report tile, selecting a date from the new slicer should update everything else. 

Helpful resources

Announcements
July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.