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 table. relation is one-to-many with both type filter option.

Now added date field of date dimension table to a slicer and want to filter candidate table data on date basis.

But its not working.

 

Please help me , Its urgent for me.

 

Regards,

Swapna.

Need Help

10 Replies

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

    swapna

    Can you elaborate? I have created a report with similar functionality and it is working fine.

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