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 Everyone,
I'm new in power bi and have some problems with the date in the Gantt, specialy in the month of the star and end of every task, it shows like "19-00-2018". I already try with the format of the date but nothing change.
Thanks for your help
Solved! Go to Solution.
@lfvc1984,
In your scenario, you should firstly change data type of the date columns correctly in Query Editor of Power BI Desktop. Please check the attached PBIX file for more details.
Regards,
Lydia
@lfvc1984,
I am unable to reproduce this issue in Power BI Desktop July release, could you please share sample data of your table?
Regards,
Lydia
There is, thanks!!
@lfvc1984,
Do you use Power BI Desktop July release? I am unable to reproduce this issue, please share sample data of your table here.
Regards,
Lydia
Yes, i have Power BI Desktop July release and still.
This is the data table:
@lfvc1984,
Could you please share the Excel file through OneDrive so that I can download?
Regards,
Lydia
@lfvc1984,
In your scenario, you should firstly change data type of the date columns correctly in Query Editor of Power BI Desktop. Please check the attached PBIX file for more details.
Regards,
Lydia
Thanks!!
Please could I get some help on this
I have a table with the date field format correctly displaying with dd-MMM-yyyy (18-Sep-2020).
I want to use the date field in a Gantt chart, as a 'Resource'. So that the date is displayed adjacent to the milestone shown on the Gantt chart
The Gantt chart is showing the date field totally incorrect, in what looks to be UTC format - how do I fix this?
"Tooltip settings" is the only place where you can specify Date format, and that correctly works for the Tooltip, but I'm talking about the actual "Resource" not the Tooltip. To confirm, the table is displaying the date format correctly.
See picture below for the problem
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 | |
94 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |