Forum Discussion
KevinsKanban
2 years agoFrequent Visitor
When Slicer uses a date range, the format is inconsistent after publishing to the service.
While editing on desktop [2020/1/1] [2022/8/31] After publishing to the service [1/1/2020] [31/8/2022] desktop version:
- 2 years ago
Hi KevinsKanban ,
You can try this -
- Open your PBIX file > Go to Transform Editor (Power Query Editor)
- Select the Date Column > Right Click on Column Name> Change Type > Using Locale
- Once you click on Using Locale, a window pops-up with the below options
- Change Data Type to Date or DateTime and Locale to your desired locale type
- And click on OK and apply the transformations and publish to service
I hope it will be helpful.
Thanks,
Sai Teja
SaiTejaTalasila
Super User
2 years agoHi KevinsKanban ,
You can try this -
- Open your PBIX file > Go to Transform Editor (Power Query Editor)
- Select the Date Column > Right Click on Column Name> Change Type > Using Locale
- Once you click on Using Locale, a window pops-up with the below options
- Change Data Type to Date or DateTime and Locale to your desired locale type
- And click on OK and apply the transformations and publish to service
I hope it will be helpful.
Thanks,
Sai Teja