Forum Discussion

swapna's avatar
swapna
Frequent Visitor
9 years ago

How to use date filter in slicer.

Hi,   I have created a date dimension table using DAX. Having another table named candidate. Created relationship between date field of date dimension table with created date field of candidate t...
Need Help
vanessa's avatar
vanessa
Icon for Post Patron rankPost Patron
9 years ago

swapna

Can you show me the date data in the candidate table?

swapna's avatar
swapna
Frequent Visitor
9 years ago

vanessa

 

candidate table created_date datatype - CURRENT-TIMESTAMP

 

Please let me know any more info you required.

 

Regards,

Swapna.

  • robofski's avatar
    robofski
    Icon for Resolver II rankResolver II
    9 years ago

    swapna  When I first started using a date table my problem was that my slicers were using the Date field from my FACT table not my Date table.  Worth checking.

    • swapna's avatar
      swapna
      Frequent Visitor
      9 years ago

      robofski

       

      In my case , slicer date is coming from date table.

       

      Regards,

      Swapna.

      • vanessa's avatar
        vanessa
        Icon for Post Patron rankPost Patron
        9 years ago

        swapna

         

        Can you make sure that the slicer is targetting the grid?