Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

Line chart latest month days

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

 

nv1950_0-1679414908196.pngnv1950_1-1679415052990.png

Thanks

6 REPLIES 6
BrianConnelly
Resolver III
Resolver III

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

Anonymous
Not applicable

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.

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

Anonymous
Not applicable

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

nv1950_2-1679502555738.png

 

nv1950_1-1679502518864.png

 

nv1950_0-1679502407593.png

 

rautaniket0077
Resolver I
Resolver I

Try removing 0 from measure.

Anonymous
Not applicable

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

 

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.