Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

How to make Line Chart stop mid-graph for future dates

I've made a line chart showing 3 lines, each is a Percentage (y-axis) over Time (x-axis): 1. A "goal" line that has pre-populated data (see black line below) 2. Two data lines showing progress rela...
Need Help
Tips and Tricks
  • Reid_Havens's avatar
    Reid_Havens
    9 years ago

    Hi Jason,

     

    Happy to help. If this is a numerical column then you might want to try using the BLANK() function. My first thought would be to write an IF statement asking of the Date on your axis is less than or equal to today's date. If true then it would return the value from your formula, if false it would return BLANK(). So something potentially like this. Let me know if this helps or gets you closer.

     

    =IF( Table[Date] <= TODAY(), [Formula], BLANK() )

Reid_Havens's avatar
Reid_Havens
Most Valuable Professional
9 years ago

Fantasic. Good evolution of the formula and glad you were able to find a solution.

acrow's avatar
acrow
New Member
7 years ago

Hi, I have managed to get my cumulative measure to stop at a particular point (Cost Period = 4) and fill the future with BLANK()

 

However when plotting using Line Chart the Yellow line just goes horizontal (flat line) even though values are BLANK.

 

Can anyone advise what I am doing wrong?

 

 

  • acimisliin's avatar
    acimisliin
    Regular Visitor
    7 years ago

    Hi,

    Please check this DAX measure:

     

    Cumulative NSI = IF( MAX('Calendar'[Date]) > TODAY(), BLANK(),
    CALCULATE(
    SUM(AllBusinessSales[NSI]),
    FILTER(
    ALLSELECTED( 'Calendar' ),
    'Calendar'[Date] <= MAX('Calendar'[Date])
    )
    )
    )
     
    The trick is to put BLANK() after today.