Wrong date filter with parameter

[Analitika]

45

312

6

What is wrong? Column fomated as date, when i filter wiht parameter i got wrong chart.

[danextian]

Hi @Analitika 

What do you mean by you've got the wrong chart? Can you please post your expected result. 1/1/2017 is a valid date in either US or UK/AU format. It seems that you are trying to filter a dates table from the data source  in Power Query instead of using a slicer to filter your visuals.

[Analitika]

yes im trying to filter a dates table from the data source  in Power Query  with parameter. I want reduce size and time of downloaded data, filtering by date

[V-lianl-msft]

Hi @Analitika ,

Is there an error in applying parameter query?
See if this blog can help you:https://blog.crossjoin.co.uk/2016/08/30/data-driven-power-bi-desktop-parameters-using-list-queries/ 

https://www.biinsight.com/power-bi-desktop-query-parameters-part-3-list-output/ 

https://medium.com/dm-p/dynamic-filtering-with-power-bi-what-if-parameters-43ab4953de68 

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