Forum Discussion
Using localized date hierarchies
Hi Anonymous,
Nope, you can't modify the default date hierarchy locale that analysis by power bi itself. In my opinion, I'd like to suggest you create a calendar table and add custom columns to extract and convert to different data region language, then use these fields with common date fields to create custom hierarchy
Regards,
Xiaoxin Sheng
Creating custom column cannot be a solution, because it is simply not manageable. First, it would require to create literally dozens of custom columns for each of the dozen languagaes. Second, it is unclear how would the design look in this case. Imagine we have a monthly slicer that has to have month names on it. How do we design it so it has italian names for client with italian locale, russian for russian client and english for english? As far as I can see, there is no solution to this.
So short answer, platform does not support locale-aware period names for key feature that is promoted as a pillar for sorting out all date-related information - calendarauto() tables.