How to use date filter in slicer.

[swapna]

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.

[v-huizhn-msft]

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]

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]

@swapna

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

[swapna]

@vanessa

candidate table created_date datatype - CURRENT-TIMESTAMP

Please let me know any more info you required.

Regards,

Swapna.

[robofski]

@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]

@robofski

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

Regards,

Swapna.

[vanessa]

@swapna

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

[swapna]

@vanessa

First image desicribes when slicer and candidate data loaded.

Second image if i am applying the filter the grid becomes blank although data is present for the filtered date.

Regards,

Swapna.

[v-huizhn-msft]

Hi @swapna，

It's weird. Please restart your PowerBi desktop and check if it works fine.

Best Regards,
Angelia

[vanessa]

@swapna

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