cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

3 Tables, 1 date slicer

I feel like this is probably an easy question and i'm just not seeing the obvious.  I've got 3 tables, Site List, Materials Processed, Hours.  Site List has a 1 to Many relationship with both tables.

 

I've created a report with a Timeline Slicer that uses the dates from the Materials Processed Data table.  I've created some measures that get a SumX of Materials Processed and a SumX of Hours data.  I then have a last measure that is a Materials Processed divided by the hours.  These measures are within the Site Table.

 

The problem I am facing is that while date slicer is correctly limiting the Materials Processed to whichever date range is selected, its not effecting the Hours data.  I was hoping that the same date limitation would be applied to the Hours table, but i've not been able to make it do it.  Both tables have a date field both with the same name and of type 'Date'.

1 ACCEPTED SOLUTION
GilbertQ
Super User
Super User

Hi @Anonymous,

 

To solve your current question, what you need to have is a Date table, and then link your 3 tables Site List, Materials Processed, Hours to the Date table via a relationship.

 

If you need to understand what a Date table does you can read this blog post: Do You Need a Date Dimension?


Next if you now want to go ahead and create a date table, here is my blog post explaining how to easily do this: Power BI – How to Easily Create Dynamic Date Table/Dimension with Fiscal Attributes using Power Query

 

And once you hvae created the relationships, you can then create your date slicer from the Date table. Which will then filter all the tables included in the relationships.





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

Proud to be a Super User!







Power BI Blog

View solution in original post

3 REPLIES 3
GilbertQ
Super User
Super User

Hi @Anonymous,

 

To solve your current question, what you need to have is a Date table, and then link your 3 tables Site List, Materials Processed, Hours to the Date table via a relationship.

 

If you need to understand what a Date table does you can read this blog post: Do You Need a Date Dimension?


Next if you now want to go ahead and create a date table, here is my blog post explaining how to easily do this: Power BI – How to Easily Create Dynamic Date Table/Dimension with Fiscal Attributes using Power Query

 

And once you hvae created the relationships, you can then create your date slicer from the Date table. Which will then filter all the tables included in the relationships.





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

Proud to be a Super User!







Power BI Blog

Anonymous
Not applicable

Thanks! I knew it would be something easy that i had overlooked.

Hi @Anonymous,

 

Glad to have helped.





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

Proud to be a Super User!







Power BI Blog

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

BizApps LATAM 2023

Business Application LATAM Summit 2023

Join the biggest FREE Business Applications Event in LATAM this February.

Power Platform Bootcamp

Global Power Platform Bootcamp

In this bootcamp we will deep-dive into Microsoft’s Power Platform stack with hands-on sessions and labs, delivered to you by experts and community leaders.