Data is not filtering between date and fact tables, Even after having Many to one Relationship.

[Ubedulla1988]

Hi Team,
I have date column in fact table and I created date table using MIN and MAX dates based on the created column.
I created the one to may relationship between date and fact table. Data types are Date for both the columns, Still data is not filtering as for the short month from date table. When i change the data type from date to text for both the columns I columns I could see the data filtering. 

Please help me with issue, what could have gone wrong.

Thanks.

[Anonymous]

Thanks for the reply from lbendlin , please allow me to provide another insight:

Hi  @Ubedulla1988 ,

In my scenario, both date types and text types can be filtered properly, and I cannot reproduce your scenario

You check whether the filtering direction of the two table connections is unidirectional, if table A filters table B unidirectionally, the data of table A can affect table B, but the data of table B can't affect table A.

Are you using RLS?

By default, row-level security filtering uses single-directional filters, whether the relationships are set to single direction or bi-directional. You can manually enable bi-directional cross-filtering with row-level security by selecting the relationship and checking the Apply security filter in both directions checkbox. 

Row-level security (RLS) with Power BI - Microsoft Fabric | Microsoft Learn

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin · Accepted solution]

Could be that your dates are actually datetimes with time components.

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.

Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

[Ubedulla1988]

Hi  lbendlin 
Thanks for respondig on issue.
Both the columns are Date data type and format is short date. It is sensitive informaiton which i can't share.