Forum Discussion

TBenders's avatar
TBenders
Helper II
9 years ago
Solved

Limit Endless X-Axis to date

Hi there,   I have a couple of graphs which gets values from measure in the future. Because of this, graphs go on endlessly. My field of business is Recruitment and I have added formula-examples th...
Need Help
  • v-ljerr-msft's avatar
    v-ljerr-msft
    9 years ago

    Hi TBenders,

     

    In this scenario, you can add a IF statement to tell if the date on X-Axis is less or equal that current date(TODAY()) first, then show the value you want accordingly. The formula below is for your reference.:smileyhappy:

    Candidates Contacted =
IF (
    MAX ( CalendarDisconnected[Date] ) <= TODAY ();
    CALCULATE (
        COUNTROWS ( FILTER ( 'Applications'; 'Applications'[Status] = "Contacted" ) )
    )
        + 0
)

    Regards

v-ljerr-msft's avatar
v-ljerr-msft
Microsoft Employee
9 years ago

Hi TBenders,

 

In this scenario, you can add a IF statement to tell if the date on X-Axis is less or equal that current date(TODAY()) first, then show the value you want accordingly. The formula below is for your reference.:smileyhappy:

Candidates Contacted =
IF (
    MAX ( CalendarDisconnected[Date] ) <= TODAY ();
    CALCULATE (
        COUNTROWS ( FILTER ( 'Applications'; 'Applications'[Status] = "Contacted" ) )
    )
        + 0
)

Regards

TBenders's avatar
TBenders
Helper II
9 years ago

Thanks a lot!