Forum Discussion

NielsDecoene's avatar
NielsDecoene
Helper I
9 years ago

Issue filtering a FullDate Hierarchy

I have a problem while making a report on a Data Warehouse I have 4 visuals with calculations that play with Date/Time example: AffectedArticlesLastTwoMonths = CALCULATE( SUMX(FILTER(F_Defects_Tic...
Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi NielsDecoene,

What date values does the DateFull field contain? Based on my test, if the DateFull field contains date values from Jan 2016 to Dec 2016, it will show all the values in the slicer once you drag the field into custom Hierarchy Slicer.

In addition, do you create a visual using Market Defects and DateFull field? If that is the case, when you drag Last12Months into another Hierarchy Slicer, how does the visualization perform?

Thanks,
Lydia Zhang

NielsDecoene's avatar
NielsDecoene
Helper I
9 years ago

Hey Anonymous

 

As said the D_FilteredDate comes from D_Date (typical date dimension created from stored procedure)

the D_FiltereDate is a piece of D_Date it starts at a specific day in time (somewhere 2011) and it changes dynamically to

the last full month that's come around, so currently we're 09/11/2016 it will contain everything till 31/10/2016.

 

The graph has 

Market Defects as Value and as Axis Datefull (Year Month)

 

If i take the working version and i create a second hierarchy slicer also impacting this visual:

It changes the values on each month to something incorrect. 

I will try and make some data during lunchbreak.