Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
Have a column in table delivery time which comes in as date/time but we wish to show this in report as just the time.
In one pc on power bi desktop it shows correctly as hh:mm i..e time but on another and on the service it shows as the date even though try and format as time as per below.
What is best way to resolve this?
I've had to manually go in and chnage them to date/time datatype and time format as if some binding issue.
The power bi .pbix current file has regional settings set as English UK already.
Thanks
Solved! Go to Solution.
Thanks for info.
Essentailly just changed to date/time datatype in power bi and time fromat and looks o.k now.
@po , Power Bi service can use browser's regional setting
refer
https://nform.com.au/how-to-change-the-date-format-in-the-power-bi-service/
Thanks for info.
Essentailly just changed to date/time datatype in power bi and time fromat and looks o.k now.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
95 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |