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 All,
My published reports are changing the date format to show the day month month number year e.g. Saturday October 01 2016
In Desktop they are set to Long date e.g 01 October 2016
How can I change this? As it is messing up my visuals by elongating the columns.
Any help, much appreciated.
Solved! Go to Solution.
Morning @v-robertq-msft
Thanks for your response, that is exactly what I did. I had a play with the date format and discovered that if you choose the lower versions and not the top version Long and Short, that it worked the way I wanted it to.
Refreshing the report and checking the output each time.
Hi,
According to your description, you said that your date format is too long to mess up your visuals when published to the Power BI service.
I think you can simply solve this problem by changing the date format to the short type like “yyyy/mm/dd” in the Power BI Desktop and publish the report again the overwrite the original report, and the date format will be changed to the short type.
Thank you very much!
Best Regards,
Community Support Team _Robert Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Morning @v-robertq-msft
Thanks for your response, that is exactly what I did. I had a play with the date format and discovered that if you choose the lower versions and not the top version Long and Short, that it worked the way I wanted it to.
Refreshing the report and checking the output each time.
Sorted, I have changed the format to the dd mmmm yyyy and not used the default long Date
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 |
---|---|
60 | |
20 | |
18 | |
18 | |
9 |