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.
5 Comments
- Javed_AsifNew Member
Very important in my organization because both English and French are official languages.
- Al-Braich_HasanNew Member
100%
- fbcideas_migusrNew Member
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.
- Ashish_ChhattanNew Member
100%
- fbcideas_migusrNew MemberStatus added:New
Recent ideas
Semantic model connection bindings should be in source control (Git)
Semantic model data source connection bindings should be source controlled. A semantic model can contain multiple data source references, each of which can be mapped to a separate Fabric data connec...frithjof_v4 hours agoCommunity ChampionNew10Views1like0CommentsBulk changing column names in Visualizations Pane
We often use raw/api column names or measures with a set nomenclature to be consistent and to keep track of them but we do not want to display these names in the visuals. Currently we have to change ...vishal1401978 hours agoFrequent VisitorNew5Views0likes0CommentsAbout "Download SQL database project" and fix the downloaded project
1. The sqlproj must be fixed, it is downloaded without the xml markup line <?xml version="1.0" encoding="utf-8"> 2. The sdk must be updated: Actual: <Sdk Name="Microsoft.Build.Sql" Version="0.1...Jarrinf17 hours agoFrequent VisitorNew48Views3likes2Comments