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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
evester
Helper II
Helper II

How to create one date slicer with multiple date fields from multiple tables

I have three tables in my report.  Each table has a date field.  I would like to create one date slicer that will control all three tables, however, in each of my tables the date fields have different names- Transaction Date, Received Date and Transaction Date.  I have tried synching and grouping the slicers but it does not control all three tables.  Here is my sample report.  

 

evester_0-1665064225872.png

 

Here is my model.  I have all three talbes connected to the date table. 

evester_1-1665064327426.png

Any help would be greatly appreciated.  Thank you in advance! 

 

 

4 REPLIES 4
serpiva64
Super User
Super User

Hi,

have you tried using only one slicer with Date from DimDate?

Yes  I tried using the date from the DimDate, it will only filter two of the tables not all three.

Which one is not filtering? Be sure of that relationship.

Well, I tried to set up the slicers to filter by Year, Month and Day.  I cant get that hierarchy to show in the filters.  The third table will not filter. 

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel1

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.