The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Can anyone please tell me why the data points misalign with the month end dates on my line chart? When I show it as a table, everything looks correct. Please let me know how to fix this issue. Thanks!
Solved! Go to Solution.
Make sure your Date Dimension table has the following columns:
Month_Year = FORMAT(Date_Table[Date], "mmm yyyy")
End_of_Month = EOMONTH(Date_Table[DATE], 0)
Then sort "Month_Year" by "End_of_Month". (Sort by column option in table view). This will help you ensure that your X axis is sorted properly.
Then use the "Month_Year" column as your x-axis value, instead of "Month Ending". Now you might be able to choose "continuous" and have it not look strange. Let me know if this helps.
When you think about it, June 30th 2023 SHOULD actually be displaying as immediately prior to the beginning of July 2023. The graph is not actually displaying anything incorrectly.
But if it bothers you being presented this way, and you are okay with every month being labeled, you can fix it by changing the X axis to "Categorical" rather than "Continuous".
///Mediocre power bi advice, but it's free///
Thank you. But if change it to "Categorical", the "Forecast" function won't be available any more under the Analytics.
Make sure your Date Dimension table has the following columns:
Month_Year = FORMAT(Date_Table[Date], "mmm yyyy")
End_of_Month = EOMONTH(Date_Table[DATE], 0)
Then sort "Month_Year" by "End_of_Month". (Sort by column option in table view). This will help you ensure that your X axis is sorted properly.
Then use the "Month_Year" column as your x-axis value, instead of "Month Ending". Now you might be able to choose "continuous" and have it not look strange. Let me know if this helps.
Thank you very much. The line chart does look correct following the steps above. It's very interesting to see that you can actually sort the "Month_Year" column by "End_of_Month" columns, even if the "End_of_Month" column contains duplicated records. Previously, I thought that you could only select "Sort by column" if that column contains unique data.
However, the option to toggle X-axis between continuous and categorical is missing, and I am still not able to forecast anything. Oh well, I don't see a better way at the moment, so I will accept it as the solution. Thank you again!
User | Count |
---|---|
78 | |
73 | |
38 | |
30 | |
28 |
User | Count |
---|---|
107 | |
100 | |
55 | |
49 | |
45 |