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
v-huizhn-msft's avatar
v-huizhn-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi swapna,

As I tested, it can works fine. Could you please share your .pbix file for further analysis? We only can test and post solution closed to your requriement based on your data.

Best Regards,
Angelia

swapna's avatar
swapna
Frequent Visitor
9 years ago

Candidate TableRelation between candidate and Date table

 

Hi,

 

I have attached the images . 

First one is Date Dimension table.

Second one is Candidate table.

Relation window also attached.

Please let me know any more information required.

 

Regards,

Swapna.

  • 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.