Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
What is wrong? Column fomated as date, when i filter wiht parameter i got wrong chart.
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.
Proud to be a Super User!
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
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |