Forum Discussion

raschdieek's avatar
raschdieek
Frequent Visitor
10 months ago
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 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. 

 

  • raschdieek's avatar
    raschdieek
    9 months ago

    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.