Forum Discussion
Solved
Creating date slicer removes data
Problem - when creating a "Date" slicer for information in my visual, I lose data from a table I have set up. Example: Setting up a slicer based on the Date table, you can see there is a range t...
v-hashadapu Thanks for your help.
I would consider this resolved. I can transform the data that is pulled into the model from DirectQuery as well. This is suitable for my needs.
Hi raschdieek
Do you need those future dates? Have you tried removing overly future dates from your dates table? Say only up to 2027.
Thanks for the reply. No, I do not need the dates that far out, but it is not the issue.
The issue looks to be that the underlying data that gets filtered still has a time stamp associated with it, even though in PowerBI I set the column data to Date data type and Short Date format.
Visually I do not see the time stamps, but the query to our database still contains a time stamp.