Forum Discussion
date filter not work
I use column date as a filter for my data in this report but it not work, what is the problem?
the date and other data in different tables and there are one to many relationship between them.
4 Replies
waleed111 , Really less information to check.
Hope the relationship is active.
Interactions are on https://docs.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions
Can you share a sample pbix after removing sensitive data.
how can i share my pbix file, i didn't find file uploding icon.
Hi waleed111 ,
If you've fixed the issue on your own please kindly share your solution.
If it doesn’t, could you please provide a mockup sample based on fake data?
It will be helpful if you can show us the exact expected result based on the tables.
Please upload your files to OneDrive For Business and share the link here. Please don't contain any Confidential Information or Real data in your reply.
Best regards,
Community Support Team _ zhenbw
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
waleed111 - Could be missing relationship? Not clear from the picture what is going on, I don't see any filtering going on in the Filters pane. Doesn't look like your Date field is being recognized as an actual Date but rather text. Did you build that hierarchy yourself? Notice the "Count of..." That shouldn't be there.
