Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
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
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.
candidate table created_date datatype - CURRENT-TIMESTAMP
Please let me know any more info you required.
Regards,
Swapna.
@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.
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.
Hi @swapna,
It's weird. Please restart your PowerBi desktop and check if it works fine.
Best Regards,
Angelia
Can you elaborate? I have created a report with similar functionality and it is working fine.
User | Count |
---|---|
93 | |
83 | |
77 | |
74 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
60 |