pareto chart problem

hi While i was trying to create a sample file, i found out what the problem was - because i coudlnt recreate the problem in the sample file. The date was the problem - i am using the date from a calendar table when i remove that the problem is gone but I need a date filtering option and when i use the date from the pareto table it will not format it as date, when if i have changed the format from PBI QUery

Should you by any chance happen to know why this happens?