topic Re: Line chart latest month days in DAX Commands and Tips

Line chart latest month days

Anonymous — Tue, 21 Mar 2023 16:18:10 GMT

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

Re: Line chart latest month days

rautaniket0077 — Tue, 21 Mar 2023 17:16:47 GMT

Try removing 0 from measure.

Re: Line chart latest month days

BrianConnelly — Tue, 21 Mar 2023 18:29:49 GMT

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".

Re: Line chart latest month days

Anonymous — Wed, 22 Mar 2023 11:40:54 GMT

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

Re: Line chart latest month days

Anonymous — Wed, 22 Mar 2023 11:42:32 GMT

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.

Re: Line chart latest month days

BrianConnelly — Wed, 22 Mar 2023 15:37:20 GMT

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

Re: Line chart latest month days

Anonymous — Wed, 22 Mar 2023 16:29:59 GMT

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