Forum Discussion
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:
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
2 Replies
SaiTejaTalasilaSuper User
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
- ibarrau
Hi. Usually PowerBi Service is kind of tricky because it consider regional settings that can be confusing. For example, it changes thousands separators, decimals, dates formats that would match the Browser regional settings. You can try changing another browser settings. There are settings that could work for this change, like going to the semantic model settings, then "general" tab. That would should language settings of "Default (language browser)". I think that's only for language but you can try if also changes regional setting for formatting. Otherwise it's just browser.
I hope that helps,
