Forum Discussion
Limit Date Slicer to Only Dates In Fact
I have a date dimension I use for date intelligence and I would like to have my slicer when using that dimension to only offer ranges within the fact table.
For example, the image below is from a report connected to a fact with data from 2016 to today but the dimension table is configured for 2010 to 2027 since it is used with multiple facts.
What is the best way to handle this dynamically?
Hi The_Marc_Rohde ,
How about creating relationships between the calendar table and fact table? The date will join with exact date. If it showing 1-1 or 1 to Many relations nothing to worry.
Or you can create a new date table from your dates in Fact table like this:
Calendar 2 = CALENDAR(MIN('Fact'[Date]),MAX('Fact'[Date]))Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
Hi The_Marc_Rohde ,
How about creating relationships between the calendar table and fact table? The date will join with exact date. If it showing 1-1 or 1 to Many relations nothing to worry.
Or you can create a new date table from your dates in Fact table like this:
Calendar 2 = CALENDAR(MIN('Fact'[Date]),MAX('Fact'[Date]))Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.