I'm attempting to create a line graph using the data from excel saved in CSV format. The issue is that because of the conversion the PBI is reading the data as Jan 1, Jan 2 instead of Jan 1, Feb 1. As as a result my line graph (below) is not showing monthly split. Whats the quickest way to make the fix the dates on PBI? Apologies if this question has already been asked - new to PBI and still getting used to the community. TIA!
Incorrect line graph
Correct line graph
Solved! Go to Solution.
Yes, I did. Pls see beloe the data points.
One more thing, I noticed that my model looks a bit different from the sample solution model. Could this be the reason.
Really appreciate all your help and guidance, much appreciated!
Currently your dates are not recognized with the correct Locale format. You need to go to Power Query Editor, remove the auto-generated "Changed Type" step from "Applied Steps" pane, then change data types of all columns manually. For these date columns, change them to date type with locale English (United Kingdom). This will make Power Query recognize the correct day and month values. After that, apply the queries to Power BI Desktop and try dragging a date column to a table visual to check whether the date values are correct. Ensuring date values are correct is the first step before everything.
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
I double checked this - as you can see even after the locale changes in your solution the numbers are still in the same format i.e. Jan 1, Jan 2, and so on.
@JorgePinho Thank you for the suggested solution. I have updated the columns for each of the data points, (forecast, actual and budget) however the issue still persists!
As you can see in below screen shot, when I drill down it still only shows the years and the numbers are significantly higher than the correct file shared in my initial post.
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!
Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.