Forum Discussion
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 that is greater than the listed order dates.
When the slicer is "used", but without changing any dates, data is now lost. It caps dates at 8/21/2019.
Sources - Date table (import), Order data table (direct query)
Date column from Date table is set up as a Date data type, and set to Short Date format.
Order Date column from Order data table is set up Date data type, and set to Short Date format.
Relationship - From Date table, Date Column to Order data table, Order Date column, 1 to Many cardinality, active relationship, single direction.
Table relationship link
Table relationship link details
I'm honestly at a loss of what is going on, and at a loss based on a lot of the other threads I've been looking through.
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.