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
Making Fabric UI more data engineer friendly - After new updates to functionality
In the new Fabric UI view, every different web browser, and Web browsers tabs, now persists all your open artifacts and the workspace associated with this in the left hand menu. This maybe a good ...DemoFour24 minutes agoContinued ContributorNew179Views8likes2CommentsAdd a Native Option to Distinguish "No Selection" from "Select All" in Slicers
Summary Today, Power BI slicers treat “Select All” and “No Selection” as equivalent filtering states. While this behavior is technically efficient, it is often unintuitive for report consumers. M...ealco-mc3 hours agoNew MemberNew3Views0likes0CommentsHybrid appearance: Dark mode UI with light/white Data (Table) view grid
Summary Power BI Desktop Dark mode applies to the entire application, including Table/Data view. Report themes can style visuals on the report canvas, but they do not change the Data view grid. Ther...Aryadne_Rocha7 hours agoNew MemberNew5Views0likes0CommentsRoll back a report through the deployment pipeline without effecting any artifacts in both stages.
Let's consider environment of three stages: DEV → UAT → PROD A report was accidentally published directly to PROD, bypassing the deployment pipeline. The report has already been distributed to s...v-viputta18 hours agoMicrosoft EmployeeNew27Views9likes0CommentsSubscribe hidden page / subscribe to a bookmark
today you can not send email remainders (subscribe) pages that are hidden. sometimes you hide pages so you can access them through bookmark but you don't want them to show in the general view. but ...eitanl8 hours agoNew MemberNeeds Votes1.1KViews96likes11Comments