Line chart latest month days

[nv1950]

Hi,

I created a line chart to show the balance movement on a daily basis, comparing few months trends.

For some dates the data is missing, so I added the formular to add zero and used a day in the chart from the manually created calendar table. The problem I have is I only have the data up to the 15th of March and the calendar dates are up to 15th of March, but on the line chart I have a can see the line until 31st of March.

How can I stop the March line at the 15th?

Below is the dax formular for total balance and charts

Total Balance =

var _TotalBalance = sum(Q1[Sum_Balance]) + 0

Return _TotalBalance

Thanks

[BrianConnelly]

Are you using a Date Dimension?  If so, have a column for the Day Number, for example..

DayNum = DAY([Date])

Then create a another column that you can filter (could use a measure as well)

Is Day Num before Today = IF(DayNum <= DAY(TODAY()), "Yes","No")

On your chart add the "Is Day Num before Today" and then select "Yes".

[nv1950]

Yes, I'm using the date dimention and added additional columns. Unfortunetly the latest month is still showing the line until the end of the month. Possibly need to add day and month.

[BrianConnelly]

Can you share some screenshots so I can see what is happening?

[nv1950]

Hi.

I don't have the data for the last day of the month, that is why in the measure I add 0 to the sum of balance. Then link the date to the calendar table and use the calendar date in X axis.

Without adding a zero the chart look like this, so the end of the month 31st or 30thth  is missing.

With the zero it looks like I want, but the latest month has future days populated.

With the new day formulars the chart breaks at just over mid month

[rautaniket0077]

Try removing 0 from measure.

[nv1950]

Without 0 the chart stops at day 30, but I want to show the dip on the last day