cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
swapna Frequent Visitor
Frequent Visitor

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.

10 REPLIES 10
vanessa Member
Member

Re: How to use date filter in slicer.

@swapna

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

v-huizhn-msft Super Contributor
Super Contributor

Re: How to use date filter in slicer.

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 Frequent Visitor
Frequent Visitor

Re: How to use date filter in slicer.

datedimension.pngCandidate.pngCandidate TableRelationWindow.pngRelation between candidate and Date tableEditRelation.png

 

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 Member
Member

Re: How to use date filter in slicer.

@swapna

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

swapna Frequent Visitor
Frequent Visitor

Re: How to use date filter in slicer.

@vanessa

 

candidate table created_date datatype - CURRENT-TIMESTAMP

Date.png

 

Please let me know any more info you required.

 

Regards,

Swapna.

robofski Member
Member

Re: How to use date filter in slicer.

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

Highlighted
swapna Frequent Visitor
Frequent Visitor

Re: How to use date filter in slicer.

@robofski

 

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

 

Regards,

Swapna.

vanessa Member
Member

Re: How to use date filter in slicer.

@swapna

 

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

swapna Frequent Visitor
Frequent Visitor

Re: How to use date filter in slicer.

Screenshot_1.pngScreenshot_2.png

 

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

Helpful resources

Announcements
GregDeckler

How to Get Your Question Answered Quickly

Power BI Super User, Greg Deckler, explains

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Ideas
Users Online
Currently online: 52 members 1,008 guests
Please welcome our newest community members: