Skip to main content

Power BI

New

Multilingual Date Table

Vote (94) Share
Ian Roberts's profile image

Ian Roberts on 04 Jan 2022 16:21:40

Established best practice for implementing multi-lingual reports at the data level (e.g. names of calendar months) is to have one row per language for this data in the appropriate tables, with a Language ID column to filter the results according to the desired language. Yet Power BI enforces a single row per date in the designated Date table for a data model. These two concepts are currently irreconcilable.

It should be possible to define multiple rows per date in the designated Date table, by introducing a mandatory and distinct Language ID against each row in that table. This would allow the use of Power BI's built-in time intelligence functions in conjunction with best practices regarding multilingual data.

Comments (4)
Ian Roberts's profile image Profile Picture

Ashish Chhattani on 21 Dec 2022 00:00:45

RE: Multilingual Date Table

100%

Ian Roberts's profile image Profile Picture

Pierre-Luc Forgette on 14 Dec 2022 13:01:41

RE: Multilingual Date Table

Same for my organization. it's a requirement for our client and it a law that our IT solution must be in French and English available for our users/customer.

Ian Roberts's profile image Profile Picture

Al-Braich Hasan on 08 Dec 2022 13:37:51

RE: Multilingual Date Table

100%

Ian Roberts's profile image Profile Picture

Javed Asif on 08 Dec 2022 13:33:51

RE: Multilingual Date Table

Very important in my organization because both English and French are official languages.