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.
I'm having an issue when typing in visual level, page level and report level filters.
I am looking to type the date, then Power BI to 'autofill' the date I was typing once I have pressed enter.
The issue: when I type "12/1" and press enter, I would expect to see 12th January 2001 (2001 being the default year in this case). However, Power BI reads "12/1" to be 1st December 2001. Is there anywhere / anyway I can change this?
Many thanks
Solved! Go to Solution.
Hi @Simon_Lou,
How about add the Date column into the Visual Level filter, and type the value in this format: "1/12/2001"?
Best Regards,
Qiuyun Yu
Hey ,
Here the format is Month Day Year.
So u can it to 1/12 , it will help u.
Or change regional setting
Hi Baskar,
I have tried this using different Locale settings and nothing changed.
Thnak you for your help.
simon
Hi @Simon_Lou,
How about add the Date column into the Visual Level filter, and type the value in this format: "1/12/2001"?
Best Regards,
Qiuyun Yu
Hi Quiyun Yu,
Yes - it appears that explicitly typing year removes the ambiguity in my issue.
many thanks,
Simon
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 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |