Forum Discussion
Date Dimension Filter Issue
Thanks for the reply and apologies on the delay...
I did create a test as you suggested and everything worked properly. When I added the date dimension to a table, it showed all dates from the date dimension table. I then added a measure from the fact table and the date range on the table was filtered appropriately based on the dates in the fact table.
One thing that may be causing the issue is that i have multiple fact tables, all with the same relationship to the date dimension. When I add a measure from a different fact table to the test table i mentioned above, the table still works properly, showing the correct measures for the right dates based on the given fact table.
So maybe my question/issue is... If I have this date relationship for a couple fact tables and I add the Date column from the Date dimension onto a page, it shows all possible dates from the date dimension. I want it to show the date range of the data from the fact table(s) I am using in the visuals. Sounds like I may need to create some type of calculated column on the Date dimension table that looks at the minimum date of all fact tables and the maximum date of all fact tables and filters the Date dimension table that way?
Appreciate the help!
"add the Date column from the Date dimension onto a page, it shows all possible dates from the date dimension. I want it to show the date range of the data from the fact table(s) I am using in the visuals"
Unless your data model is weird, that's what powerbi does. A measure that's shown in the visual should be shown if it returns a value for the date range. If there is no value, powerbi doesn't show the date. There's a 'show items with no data' option if that is required.