Forum Discussion
Line Chart PowerBI Month end date issues
Hi,
I am using a line chart which has time series data and uses a date hierarchy to sort it. As such I am getting good year, month and day visibility of data.
However I have noticed something when looking at the chart - when in the 'month' view, I would assume this shows the value at the end of that particular month when I hover over it. When I looked closer, and went down to the day view, it seemed to be taking the value of the data on 30th not 31st of that month (March) and, thus, produce erroneous data.
Is there a way of altering/checking what PowerBI is doing here as it seems to be choosing the wrong month end date to display at the high level the data that I want to see.
4 Replies
Hi tobiasmcbride ,
What column are you using for your date axis? Is it a column from the dataset or from a calendar table?
If the column is from the dataset check if there are any values for march 31st if not that is why you are not getting values on the last day of the month.
As a best practice when working with dates you should have a calendar dimension table, this calendar table must have continuous values from the 1st of January to 31st of December (start and end year at your choice) in order to not get breaks in axis or values as you are having.
When combined with other tables you should make a relationship of one ot many from the calendar table to the other tables.
MFelix the data has data/values for every date from 2 years ago until 2 years + in the future and so will cover that date.
Fact is I have that data, and it covers those dates, but I cannot see PowerBI taking the month end date as being 31st March for instance. instead seem to be taking 30th of that month despite there being 31 days?
Hi tobiasmcbride ,
As I refered I never had that issue except when there is no data in that specific date.
Is it possible to share a sample file to check?
I can't reprocude your problem.
This is my result.
Please use my simple sample or create a simple test file to show me what's your problem.
Best Regards
MaggieCommunity Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
