Forum Discussion

meyer's avatar
meyer
Regular Visitor
8 years ago
Solved

Slicer element and date dimension

Hi everybody,   Here's my data model :   There is several joins between my fact table and my dimensions ones. The first one is between GRP_AFFAIRE and ID_CLIENT and the others are between a...
Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    8 years ago

    Hi meyer,

     

    Please add a calculated column in your date dimention table. Then, add this new column to slicer, this way, the slicer will display only years that are present on fact table.

    Existing Year =
LOOKUPVALUE ( myFact[Date].[Year], myFact[Date].[Year], 'Date Dim'[Year] )

     

    Best regards,

    Yuliana Gu

v-yulgu-msft's avatar
v-yulgu-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi meyer,

 

Please add a calculated column in your date dimention table. Then, add this new column to slicer, this way, the slicer will display only years that are present on fact table.

Existing Year =
LOOKUPVALUE ( myFact[Date].[Year], myFact[Date].[Year], 'Date Dim'[Year] )

 

Best regards,

Yuliana Gu