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.
Can you elaborate? I have created a report with similar functionality and it is working fine.
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
Candidate TableRelation between candidate and Date table
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.
Can you show me the date data in the candidate table?
candidate table created_date datatype - CURRENT-TIMESTAMP
Please let me know any more info you required.
@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.
In my case , slicer date is coming from date table.
Can you make sure that the slicer is targetting the grid?
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.
Engage and empower students with Power BI!
Continue your learning in our online communities.
Travel to Melbourne and network with thousands of peers!