Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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

 

Thanks

6 Replies

  • BrianConnelly's avatar
    BrianConnelly
    Icon for Resolver III rankResolver III
    3 years ago

    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's avatar
      Anonymous
      Not applicable
      3 years ago

      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's avatar
        BrianConnelly
        Icon for Resolver III rankResolver III
        3 years ago

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

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