Hello,
Idea:
I would like the Display Language to have more options in PBI Service/Fabric Preferences, including "English (UK)", "English (AUS)", or even "English (NZ)" so we can force dynamic date formats to conform to our local norm of dd/mm/yyy.
---
I work for a Healthcare Service and getting dates in the format dd/mm/yyyy is imperative for operational reports especially when it relates to patients getting to appointments and bookings etc.
There is a Swiss Cheese Safety problem here, that if a cancer patient were to not be correctly waitlisted or given an appointment as a result of someone not seeing the treat by date correctly, then the outcome could be potentially fatal.
We do our best to block the holes in the Swiss cheese safety model, see examples below, but we would like to force the Display Language to a dd/mm/yyyy English format to eliminate the holes.
Currently we rely on browser settings, however Edge Browser settings in our Org are maintained by our Infrastructure Team, and after each desktop update, we often have to request the Browser settings be updated. (1 hole we trying to clog)
The problem often comes as a result of new staff performing such actions.
I have done lots of training with Analysts to not use the (*Dynamic Date) which is the default field in PowerBI Desktop when developing a report. That way the date shows in the dd/mm/yyyy.
But because the default date field is a dynamic date in most cases with setting up the dataset fields, it's hard for Analysts to always remember. (Another hole)
We provide PBI Training to End Users, but again, user errors occur, and big organisations frequently have new staff starting each week. (Another hole)
---
Summary:
Basically, we don't want our patients to die over something as silly as default USA date formats. Especially when these language options exist in other Microsoft Products.
Sincerely,
The Rest of the World.
3 Comments
- fbcideas_migusrNew MemberStatus added:New
- LingLuoMicrosoft EmployeeStatus changed:NewtoNeed Clarification
Can your requirement be understood as adding the option of EN-GB (for example) in the language setting of Fabric so that the PBI report can follow the setting and adjust the display format of the time and date.
Can you think of make the date/time fomat fixed when creating the report? For example:
In Power BI Desktop, convert the date field to a text format using the Format() DAX function and specify a format such as dd/mm/yyyy
This way, the format is fixed and will not change based on the language settings.
- dewitlRegular VisitorThe language settings also affects the way data formats are shown in Date slicers -- in this case the proposed workaround will not work in slicers but only in the visualizations. We would also like to have English (United Kingdom) available as language setting in Fabric/Power BI.
Recent ideas
Power BI UX Suggestion: Preserve Selection When Switching Between Report and Model Views
When developing a Power BI report, if I select a visual in Report View and then switch to Model View, the selected table/column context is lost and everything becomes unselected. This can be inconv...Murtaza_Ghafoor2 hours agoSuper UserNew3Views0likes0CommentsPower BI UX Suggestion: Preserve Selection When Switching Between Report and Model Views
When developing a Power BI report, if I select a visual in Report View and then switch to Model View, the selected table/column context is lost and everything becomes unselected. This can be inconv...Murtaza_Ghafoor2 hours agoSuper UserNew4Views0likes0CommentsDefault Scrollable Time-Series Charts to Most Recent Data
Currently, Power BI time-series charts always open scrolled to the earliest (leftmost) date by default, which is inconvenient for reports where users are interested in the most recent (rightmost) dat...CStillwell4 hours agoNew MemberNew3Views0likes0CommentsPower BI Desktop Data Load: Can We Get Better Progress Visibility?
One UX improvement I’d really like to see in Power BI Desktop is better visibility when loading large datasets from Power Query. Currently, when Power Query finishes processing and the data starts l...salmansaifee775 hours agoRegular VisitorNew16Views0likes0CommentsImprove support for calculated tables on remote semantic models
When a report is connected to a remote semantic model, Power BI Desktop allows users to create calculated tables and calculated columns based on that remote model. The issue is that this architectur...alaeddinegaaya8 hours agoNew MemberNew10Views0likes0Comments