Make month names for CALENDARAUTO() table locale-aware

[Anonymous]

We have a CALENDARAUTO() table and we use its columns such as Month, Quarter etc in various filters. Problem is, month names are always in english and do not respond to client's locale.

How do we make month names from calendarauto() locale-aware? FYI the method described here in some other post, changing locale in model settings, (i) does not work, and (ii) we need them to RESPOND to client local, not to have a fixed locale.

[v-eachen-msft]

Hi @Anonymous ,

I'd like to suggest you try to use 'use locate' option to manually setting content type to help query editor format your data type more accuracy.

[Anonymous]

This does not help at all as the information is way too generic.

There is a CALENDARAUTO() function which automatically creates e.g. Month hierarchy for calendar dates. Specific question, when using this Month column in reports and slicers, SHOULD it automatically match the user language or not?

[amitchandak]

@Anonymous , My advice would be to create an additional column for the month and year and try(create a hierarchy with if needed). Because if you mark this table as Date table, date will become key and you will not get Hierarchy

[Anonymous]

So out of the box, CALENDARAUTO() is not localized, and you suggest creating additional columns for month names for every language we are going to support? And re-designing every report page? I am not sure wherever you are even serious...

[amitchandak]

@Anonymous , refer if these can help

https://docs.microsoft.com/en-us/power-bi/fundamentals/supported-languages-countries-regions

https://community.powerbi.com/t5/Desktop/Internationalization-Localization-of-Reports/td-p/47262