Forum Discussion

Advocate I

9 years ago

Solved

How to change Date format in Filter ?

Hi,

I'm having a weird issue and i need help with it.

My local date format is mm/dd/yy wich is currently the format displaying in my query and tables,

But, when i add a filter on my presentation, the filter displays the format dd/mm/yy

how can i change that?

Thanks in advance

v-qiuyu-msft
9 years ago
Hi Raul09,

1. Check if date format for the that data field is mm/dd/yyyy.

2. Verify the locale setting in the report. See: Choose the locale of a report in Power BI Desktop.

3. Try to run the latest desktop version.

Best Regards,
Qiuyun Yu

3 Replies

v-qiuyu-msft
Community Support
9 years ago
Hi Raul09,

1. Check if date format for the that data field is mm/dd/yyyy.

2. Verify the locale setting in the report. See: Choose the locale of a report in Power BI Desktop.

3. Try to run the latest desktop version.

Best Regards,
Qiuyun Yu
- Raul09
  Advocate I
  9 years ago
  Formats are ok, and local settings too..
  
  is weird, on desktop is showing like that but when i publish it online, it shows just how i want it.
  
  so i guess i can work like that
  
  Thanks anyways
- kurianuthuppu
  Regular Visitor
  3 years ago
  This hasn't worked for me;
  Though the date format is correct in the basic variable, the same isn't getting reflected when I put the variable in the filter; can you please help.